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.
:::