03 Oct 19 · npack · #Snowflake ·   Bookmark   ×

DROP TABLE syntax in Snowflake

Removes a table from the current/specified schema, but retains a version of the table so that it can be recovered using UNDROP TABLE

drop table table_name;

More safer syntax:

drop table if exists table_name;


posted on 03 Oct 19

Enjoy great content like this and a lot more !

Signup for a free account to write a post / comment / upvote posts. Its simple and takes less than 5 seconds