The DROP TABLE statement removes the specified table from the database.
[CASCADE [CONSTRAINTS]] means that all referential integrity constraints that refer to primary and unique keys in the dropped table are removed. This means that all the foreign keys specifications are removed from tables referencing the table being dropped. However, no column values are changed in the referencing tables.
Note By default, objects are dropped with a RESTRICT type drop behavior, that is, as if the RESTRICT referential action was defined in all the related foreign keys.
However, there are exceptions such as the following:
▪If your table has a synchronization history table, that synchronization history table will be dropped automatically.
▪If a table has indexes on it, you do not need to drop the indexes first; they will be dropped automatically when the table is dropped.
Examples
DROP TABLE table1; -- Using catalog, schema, and table name DROP TABLE domains_db.demand_schema.bad_address_table; --remove foreign key constraints in referencing tables DROP TABLE table2 CASCADE CONSTRAINTS;