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

1. DROP TABLE 'TABLE_NAME';

Example

1. DROP TABLE ratings;

:::tip

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

:::