How to Truncate a Table in Snowflake
Last updated July 24, 2026 · By the SaturnSQL team
TRUNCATE TABLE removes all rows instantly while keeping the table structure, grants, and clustering keys. Unlike DROP, the table stays; unlike DELETE, no WHERE clause is possible.
TRUNCATE TABLE orders;Truncated data remains recoverable via Time Travel for the retention period, so a mistaken TRUNCATE is not fatal: recreate the data with CREATE TABLE ... CLONE ... AT or an INSERT from a historical SELECT.
Run this in SaturnSQL
SaturnSQL is a browser-based SQL editor for teams: shared query library, schema-aware autocomplete, and scheduled exports to Google Sheets and Slack.
Try it free