How to Drop a Table in Snowflake (and Undrop It)
Last updated July 24, 2026 · By the SaturnSQL team
DROP TABLE removes the table. Snowflake keeps it recoverable for the Time Travel retention period, and UNDROP TABLE restores it instantly, which makes accidental drops fixable.
DROP TABLE IF EXISTS orders_backup;Restore a dropped table
UNDROP TABLE orders_backup;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