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.
Spread the word