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.

Authorization

The privileges held by the authorization ID of the statement must include DBADM authority.

Syntax

IDAX.CLEANUP(in parameter_string varchar(32672))

Parameter descriptions

parameter_string: Optional.; Empty string or string with blank characters only. It can also be omitted.; Data type: VARCHAR(32672)

Returned information

A result set with status information is returned. It contains a success message, that is, a VARCHAR column.

If the procedure is not completed correctly, you get an error message that contains the names and sizes of the metadata tables that are not empty.

Example

CALL IDAX.CLEANUP();

 Result set 1
 --------------

 Message
 --------------------------------------------------------------
 CDFAA0872E The metadata tables have been removed successfully.

 1 record(s) selected.

 Return Status = 0