DROP TABLE

The DROP TABLE command deletes an existing table in a database.

Syntax

DROP TABLE table_name;

The above command removes the table_name table from a database.

Example

DROP TABLE students;

This example removes the students table from a database.

Contributors

Interested in helping build Docs? Read the Contribution Guide or share your thoughts in this feedback form.

Learn SQL on Codecademy