-672 OPERATION DROP NOT ALLOWED ON TABLE table_name
Explanation
The DROP operation failed for one of the following
reasons:
- The table being dropped has the RESTRICT ON DROP attribute.
- The table space or database being dropped contains the specified table, which has the RESTRICT ON DROP attribute.
System action
The DROP statement cannot be executed.
Programmer response
Before dropping the table, alter the table, specifying DROP RESTRICT ON DROP.
For DROP TABLESPACE or DROP
DATABASE, make sure that there are no other tables within the table
space or database with the RESTRICT ON DROP attribute. The following
SELECT statement can identify the tables:
SELECT CREATOR, NAME
FROM SYSIBM.SYSTABLES
WHERE TYPE = 'T'
AND CLUSTERTYPE = 'Y'
AND DBNAME = 'database_name'
AND TSNAME = 'tablespace_name';
SQLSTATE
55035