 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.
DROPTABLE<t1>;
The command handles the table as a whole. It will not fire any trigger. But it considersForeign Key definitions. If any other table refers to the table to be dropped, the DROP TABLE command will fail. The Foreign Key definition must bedropped first.
As the DROP TABLE command handles the table as a whole, it is very fast.
| Alter Table | Structured Query Language Drop Table | Temporary Table |