IDAX.DROP_MODEL - Drop a model
Use this stored procedure to drop a specified model with the specified name. You can remove models that you do not need anymore. This stored procedure drops the specified model as well as all associated model tables.
Authorization
The privileges held by the authorization ID of the statement must include at least one of the following authorities:
- CONTROL privilege on the model
- DROPIN privilege in the model schema
- DBADM authority
Syntax
IDAX.DROP_MODEL(in parameter_string varchar(32672))
Parameter descriptions
- parameter_string
- Mandatory one-string parameter that contains pairs of <parameter>=<value> entries that are separated by a comma.
Returned information
If the model does not exist, or if the caller does not have the required privileges, an exception is raised.
Example
CALL IDAX.DROP_MODEL('model=cc_nb_ewd');