DROP TABLE.md

The SQL DROP TABLE Statement

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

Syntax

DROP TABLE table_name;

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

---

SQL DROP TABLE Example

The following SQL statement drops the existing table "Shippers":

Example

DROP TABLE Shippers;

LINKS

[[DDL (Data Definition Language)]]