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;
Can I clone a table DDL and not the data?
Frank Bell Answered question January 4, 2022