Can I clone a table definition without the data in the original table?
Frank Bell Answered question February 9, 2022
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