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 used, the IF EXISTS clause causes the statement to return success if the table does not exist, rather than return an error. It does not suppress any of the other possible documented errors.
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 signalled 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 signalled.
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.
Examples
The following statement drops the class table definition from the dictionary.
DROP TABLE Class
See Also
ALTER TABLE
CREATE TABLE