DB2 SQL-Error: -672
SQLState: 55035
Short Description: OPERATION DROP NOT ALLOWED ON TABLE
The DROP operation failed for one of the following reasons: v The table being dropped has the RESTRICT ON DROP attribute. v 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Â’;