How to Drop a Table in Snowflake 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.

Cta

From Snowflake query to chart to Slack in seconds

Get to answers faster, together, with PopSQL and Snowflake