Structured Query Language/Drop Table

From Wikibooks, open books for an open world
Jump to navigation Jump to search
Alter Table Structured Query Language
Drop Table
Temporary Table

The DROP TABLE command removes the definition and all data of the named table from the database.


The command handles the table as a whole. It will not fire any trigger. But it considers Foreign Key definitions. If any other table referes to the table to be dropped, the DROP TABLE command will fail. The Foreign Key definition must be dropped first.

As the DROP TABLE command handles the table as a whole, it is very fast.