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.
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 |
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
Our work-support plans provide precise options as per your project tasks. Whether you are a newbie or an experienced professional seeking assistance in completing project tasks, we are here with the following plans to meet your custom needs:
Name | Dates | |
---|---|---|
Snowflake Training | Dec 07 to Dec 22 | View Details |
Snowflake Training | Dec 10 to Dec 25 | View Details |
Snowflake Training | Dec 14 to Dec 29 | View Details |
Snowflake Training | Dec 17 to Jan 01 | View Details |