IDAX.DROP_ALL_MODELS - Drop selected or all models

Use this stored procedure to drop the selected models or all models. Thus, you can remove all models that you do not need anymore.

When the models are dropped, all managed model components, that is, tables, views, and all metadata for the models are removed.

Authorities

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_ALL_MODELS(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.
Data type: VARCHAR(32672)
The following list shows the parameter values:
where
Optional.
Default: All models are dropped.
All column names that are returned by LIST_MODELS('format=long') can be used.

Returned information

The result set contains the following columns:

  • MODELSCHEMA (VARCHAR) for the model schema
  • MODELNAME (VARCHAR) for the model name
  • MESSAGE (VARCHAR)

    If a model is dropped successfully, the message column shows the value Dropped. If a model cannot be dropped, the message column shows an error message.

Example

CALL IDAX.DROP_ALL_MODELS();