TRUNCATE TABLE
- Boaz Raufman
Owned by Boaz Raufman
Feb 26, 2019
1 min read
Loading data...
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.