TRUNCATE TABLE

Truncates a table (deletes all rows from a table). 

Syntax

TRUNCATE TABLE [schema_name.]table_name;

Description

Internally, the command duplicates the table definition and marks the old copy for deletion. The old copy is physically deleted later by the background maintenance service. New queries will see the new (empty) copy, but in-flight queries will finish executing successfully on the old copy, as if they finished execution right before the table was truncated.

See Also

DROP TABLE