Tables That Cannot Be Dropped

Enterprise Edition Home | Express Edition Home | Previous Page | Next Page SQL Statements > DROP TABLE >

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 (in Dynamic Server) 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.
With Extended Parallel Server, you cannot drop a table specified in the FROM clause of a SELECT statement that defines a GK index.

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;

Related Information

Related statements: CREATE TABLE , DROP DATABASE , and TRUNCATE (XPS) .

For a discussion of the data integrity of tables, see the IBM Informix Guide to SQL: Tutorial. For a discussion of how to create a table, see the IBM Informix Database Design and Implementation Guide.