Drop Table
Read Structured Query Language/Drop Table study guide below. View Videos or join the Structured Query Language/Drop Table discussion. Add Structured Query Language/Drop Table to your PopFlock.com topic list for future reference or share this resource on social media.
Structured Query Language/Drop Table



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

DROP TABLE <t1>;

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.


  This article uses material from the Wikipedia page available here. It is released under the Creative Commons Attribution-Share-Alike License 3.0.

Structured_Query_Language/Drop_Table
 



 



 
Music Scenes