03 Oct 19 · npack ·       Add to Favorites  

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;

npack

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

Copied