Introducing PopSQL + dbt. The first SQL editor with built-in dbt supportRead more →

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.

Ready for a modern SQL editor?