CODEWITHSUNDEEP
snowflake-cloud-data-platformsnowflake-schema
Sarah
Sarah

Reputation: 1293

Snowflake-how to get existing table sql script

I am coming from the world of MCFT-SQL and to get a script view of an existing table I used to do right click and get sql for that table and MSSQL would just put that in the script view.

With snowflake which I am just starting today, I want to be able to get the script of an existing table, just need help in finding a quick way of scripting the existing table preferably without using python. I dont even know if its even possible to get SQL script of an existing object in this case table or not.

Doing right click on stat_table2 does not give any options, need help with that please.

enter image description here

Upvotes: 2

Views: 7446

Answers (1)

Jim Demitriou
Jim Demitriou

Reputation: 603

Try the get_ddl() function - here is the reference:

https://docs.snowflake.com/en/sql-reference/functions/get_ddl.html

Upvotes: 2

Related Questions