How to Drop a Table in Snowflake - MindMajix

When we want to delete a table permanently, we will use the “Drop” command to delete the table. This blog discusses dropping and undropping a table.

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.

Looking forward to a career in a cloud data warehousing domain? Check out the "Snowflake Training" and get certified today

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

Course Schedule
NameDates
Snowflake TrainingJun 22 to Jul 07View Details
Snowflake TrainingJun 25 to Jul 10View Details
Snowflake TrainingJun 29 to Jul 14View Details
Snowflake TrainingJul 02 to Jul 17View Details
Last updated: 28 Apr 2022
About Author

Kalla Saikumar is a technology expert and is currently working as a Marketing Analyst at MindMajix. Write articles on multiple platforms such as Tableau, PowerBi, Business Analysis, SQL Server, MySQL, Oracle, and other courses. And you can join him on LinkedIn and Twitter.

read less
  1. Share:
Snowflake Articles