Can I clone a table definition without the data in the original table?

3.15K viewsCloning and Time TravelData Cloning
0

Can I clone a table definition without the data in the original table?

Frank Bell Answered question February 9, 2022
0

YES. This is easy to do from the interface or from code. You just use the LIKE syntax like this: \nCREATE TABLE SNOWFLAKE_SOLUTIONS_TABLE_WITH_NO_DATA LIKE SNOWFLAKE_SOLUTIONS_TABLE_BEING_CREATED_LIKE_ANOTHER;

Frank Bell Answered question February 9, 2022