Can I clone a table DDL and not the data?

3.12K 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