-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