Can I change a column to be an identity column in Snowflake if it already exists?

0

Can I change a column to be an identity column in Snowflake if it already exists?

Gudrun Mahan Asked question November 30, -0001
0

There is no easy way to alter a table and change a column to an identity column if there is data in the table. If there is no data in the table then its actually easiest to add a new column which does the autoincrement and drop (remove) the existing column you wanted to alter if that is better for your table. [SIMILAR Question]

Frank Bell Answered question November 30, -0001
You are viewing 1 out of 1 answers, click here to view all answers.

Maximize Your Data Potential With ITS

Feedback on Q&A