Use the DROP TABLE statement to remove a table from the database.
Parameters, clauses, keywords, and variables
▪ CASCADE or CASCADE CONSTRAINTS: 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 that reference the table being dropped. However, no column values are changed in the referencing tables.
If the CASCADE keyword is not used and the statement execution would violate referential integrity constraints, the statement fails, with the following exceptions:
▪ If your table has a synchronization history table, that synchronization history table is dropped automatically.
▪ If your table has indexes on it, you do not need to drop the indexes first; they are dropped automatically when the table is dropped.
▪ If a view or a stored procedure references your table, your table is dropped, and the view or stored procedure fails the next time that it tries to reference the table.
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;