How to Drop a Table in Snowflake

Dropping a table in Snowflake is simple:

drop table users;

Unlike other technologies, Snowflake offers the "undo" option for this command. If you want to restore the table, you can do it using the undrop table command:

undrop table users;

With the undrop table command, data that resided in the table will also be restored.

database icon
From Snowflake query to chart to Slack in seconds
Get to answers faster, together, with PopSQL and Snowflake