Snowflake Solutions Expertise and
Community Trusted By

Enter Your Email Address Here To Join Our Snowflake Solutions Community For Free

Snowflake Solutions Community

Can I clone a table DDL and not the data?

3.53K viewsCloning and Time TravelData Cloning
0

Can I clone a table DDL and not the data?

Frank Bell Answered question January 4, 2022
0

YES. This is easy to do from the interface or from code. You just use the LIKE syntax like this: \n(okay. maybe its technically not code level DDL but it accomplishes the same thing)\nCREATE TABLE SNOWFLAKE_SOLUTIONS_TABLE_WITH_NO_DATA LIKE SNOWFLAKE_SOLUTIONS_TABLE_BEING_CREATED_LIKE_ANOTHER;

Frank Bell Answered question January 4, 2022

Sign in with google.com

To continue, google.com will share your name, email address, and profile picture with this site.

Harness the Power of Data with ITS Solutions

Innovative Solutions for Comprehensive Data Management

Feedback on Q&A