The DROP_STORAGEMGMT_TABLES procedure attempts to drop
all storage management tables.
Syntax
>>-DROP_STORAGEMGMT_TABLES--(--dropSpec--)---------------------><
The schema is SYSPROC.
Procedure parameters
- dropSpec
- An input argument of type SMALLINT. When dropSpec is set to 0, the process stops when any error is encountered;
when dropSpec is set to 1, the process continues,
ignoring any error it encounters. The input argument cannot be null.
If a null value is specified, an SQL0443 error with SQLSTATE 38553,
and token DBA7617 is returned.
Authorization
EXECUTE privilege on the
DROP_STORAGEMGMT_TABLES procedure.
The user ID that establishes
the database connection must either be the definer of the storage
management tables as recorded in the DEFINER column of SYSCAT.TABLES,
or have at least one of the following privileges:
- DBADM authority
- DROPIN privilege on the schema for these tables
- CONTROL privilege on these tables