DROP TABLE

kazumi_kerr's avatar
Published Jan 11, 2023
Contribute to Docs

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

Contribute to Docs

Learn SQL on Codecademy