SQL query syntax to drop table is
DROP TABLE schema_name.table_name [CASCADE CONSTRAINTS | PURGE]
- Schema_name : it is optional to provide schema name to which table is attached.
- table_name : name of the table to be deleted
- CASCADE CONSTRAINTS : If table is associated with another table through foreign key integrity constraint, this clause has to be specified while deletion. If specified, it will also drop foreign key constraints from other table in addition to specified one table. If not specified, database throws error for deletion in case table is having foreign key integrity constraints with other table.
- PURGE : If PURGE is speficied, table is not moved to recycle bin instead it is deleted forever.
Suppose we have following “people” table in database.
Lets execute query to delete the “people” table.
drop table people purge;
As in screenshot, after executing query table is purged. If we try to do desc query for table it will fail.
SoftFeeds 