titlesidebar_labeldescription
DROP TABLE keyword
DROP TABLE
DROP TABLE SQL keyword reference documentation.

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.

:::