SQL DROP TABLE Statement

Guides • SQL • 15/04/2021

The SQL DROP TABLE Statement

The DROP TABLE statement is used to drop an existing table in a database.

SQL

DROP TABLE table_name; 

Important:
Be careful before dropping a table. Deleting a table will result in loss of complete information stored in the table!

The following SQL statement drops the existing table “Shippers”:

SQL

DROP TABLE Shippers;

The TRUNCATE TABLE statement is used to delete the data inside a table, but not the table itself.

SQL

TRUNCATE TABLE table_name; 