DROP TABLE keyword

DROP TABLE is used to permanently delete a table and its contents.

caution

This command irremediably deletes the data in the target table. In doubt, make sure you have created backups of your data.

Syntax

DROP TABLE 'TABLE_NAME';

Example

DROP TABLE ratings;

tip

To delete the data inside a table but keep the table and its structure, use TRUNCATE.