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.

All contributors

Looking to contribute?

Learn SQL on Codecademy