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.


Better SQL for the people

Get more done with PopSQL and Snowflake