TRUNCATE TABLE keyword

TRUNCATE TABLE permanently deletes 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

Examples

TRUNCATE TABLE ratings;

note

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