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
Real-time SQL collaboration is here
Get started with PopSQL and Snowflake in minutes