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;
undrop table command, data that resided in the table will also be restored.