TRUNCATE TABLE keyword

TRUNCATE TABLE is used to permanently delete the contents of a table without deleting the table itself.

caution

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

Syntax

TRUNCATE TABLE 'table_name';

Examples

TRUNCATE TABLE ratings;

note

To delete both the data and the table structure, use DROP.