Developer Reference : Data Access Methods : SQL Engine Reference : SQL Syntax Reference : DROP TABLE
 
DROP TABLE
This statement removes a table from a designated database.
Syntax
DROP TABLE [ IF EXISTS ] table-name [ IN DICTIONARY ]
 
table-name ::= user-defined-name for the table to be removed.
 
IN DICTIONARY
See the discussion of IN DICTIONARY for ALTER TABLE.
Remarks
CASCADE and RESTRICT are not supported.
If any triggers depend on the table, the table is not dropped.
If a transaction is in progress and refers to the table, then an error is signaled and the table is not dropped.
The drop of table fails if other tables depend on the table to be dropped.
If a primary key exists, it is dropped. The user need not drop the primary key before dropping the table. If the primary key of the table is referenced by a constraint belonging to another table, then the table is not dropped and an error is signaled.
If the table has any foreign keys, then those foreign keys are dropped.
If the table has any other constraints (for example, NOT NULL, CHECK, UNIQUE, or NOT MODIFIABLE), then those constraints are dropped when the table is dropped.
The expression IF EXISTS causes the statement to return success instead of an error if a table does not exist. IF EXISTS does not suppress other errors.
Examples
The following statement drops the class table definition from the dictionary.
DROP TABLE Class
See Also
ALTER TABLE
CREATE TABLE