Usage and Examples of SQL DROP TABLE and TRUNCATE TABLE Keywords

DROP TABLE (Delete Table)

The DROP TABLE command will delete the table from the database.

The following SQL statement deletes the table "Shippers":

Example

　　DROP TABLE Shippers;

Note:Be careful before deleting a table. Deleting a table will result in the loss of all information stored in the table!

The TRUNCATE TABLE command will delete the data in the table but will not delete the table itself.

The following SQL statement clears the table "Categories":　

Example

　　TRUNCATE TABLE Categories;