Tables That Cannot Be Dropped

Restrictions exist on the types of tables that you can drop.
  • You cannot drop any system catalog table.
  • You cannot drop a table that is not in the current database.
  • You cannot drop a violations table or a diagnostics table.

    Before you can drop such a table, you must first issue a STOP VIOLATIONS TABLE statement on the base table with which the violations and diagnostics tables are associated.

The following example removes two tables in the current database. Both are owned by joed, the current user. Neither table has an associated violations or diagnostics table, nor a referential constraint or view defined on it.
DROP TABLE customer;
DROP TABLE stores_demo@accntg:joed.state;