Stored procedures for administrative operations

By using these stored procedures, you can do administrative operations on model metadata objects.

IDAX.CLEANUP - Drop all metadata objects
Use this stored procedure to drop all metadata objects provided that all the metadata tables are empty. If the metadata tables contain models, use the IDAX.DROP_MODEL or IDAX.DROP_ALL_MODELS stored procedures to delete these models first.
IDAX.INITIALIZE - Create the database objects for managing the metadata of the analytic models
Use this stored procedure to create the database objects for the current database that are required to manage the metadata of the analytic models.
IDAX.IS_INITIALIZED - Determine whether the database objects for managing the metadata of the analytic models are created
Use this stored procedure to determine whether the metadata objects are created, and whether the version of the metadata objects is as expected.

Parent topic: Administrative operations on model metadata objects