Snowflake Solutions Expertise and
Community Trusted By

Enter Your Email Address Here To Join Our Snowflake Solutions Community For Free

Snowflake Solutions Community

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.

Sign in with google.com

To continue, google.com will share your name, email address, and profile picture with this site.

Harness the Power of Data with ITS Solutions

Innovative Solutions for Comprehensive Data Management

Feedback on Q&A