How to Drop a Table in Snowflake

Drop a Table in Snowflake

In Snowflake, Dropping the Table is an easy process

Drop table user1;

Contrary to other platforms; Snowflake provides an “undo” facility for the “drop” command. If we have to restore the table, we do it through the “undrop table” command:

undrop table users;

Using “undrop table” command, the data available in a table can be restored.

Conclusion

We can drop and undrop the tables in Snowflake through “drop” and “undrop” commands. I hope this information is sufficient for dropping and undropping the tables. 

If you have any queries, let us know by commenting below. 

Snowflake Related Articles

▶  Snowflake vs Redshift
▶  Snowflake vs BigQuery
▶  Snowflake vs Databricks
▶  Snowflake vs Azure
▶  Snowflake vs Hadoop

▶  Snowflake Time Travel