TRUNCATE statement

Synopsis

TRUNCATE TABLE table_name

Syntax diagram

Read syntax diagramSkip visual syntax diagram TRUNCATE TABLEtable_name

For information on reading syntax diagrams, see How to read syntax diagrams

Description

Deletes all rows from a table but not the table itself. It retains the table structure like columns, constraints, and indexes.

Examples

Truncate the table orders:
TRUNCATE TABLE orders;