05-04-2022 05:00 AM
How can we alter table with auto increment column for a delta table
I have tried this but not working:
ALTER TABLE dbgtpTest.student ADD COLUMN Student_Id identity(100,1)
any Suggestions will be helpful
05-07-2022 04:11 AM
@Rakesh Reddy Badam , For ALTER ... ADD COLUMN in doc is only SYNC IDENTITY.
If you want to add an identity column to the existing table just create a new table with an identity column and then copy the data.
05-05-2022 11:28 PM
@Rakesh Reddy Badam , I am not sure if that is supported. I only find references to creating an ID column with the CREATE TABLE statement.
05-07-2022 04:11 AM
@Rakesh Reddy Badam , For ALTER ... ADD COLUMN in doc is only SYNC IDENTITY.
If you want to add an identity column to the existing table just create a new table with an identity column and then copy the data.
05-12-2022 08:35 AM
Hi @Rakesh Reddy Badam , Just a friendly follow-up. Do you still need help, or @Hubert Dudek (Customer) and @Werner Stinckens 's response help you to find the solution? Please let us know.
06-02-2022 03:57 AM
Hi @Bittu6084 (Customer) , Just a friendly follow-up. Do you still need help?
06-21-2022 08:13 PM
Hi, I have the same concern. What's the best way to achieve this?
07-07-2022 04:27 AM
Hi @Peiran Quan, This option is only supported for identity columns on Delta Lake tables.
Please read the article here.
Join our fast-growing data practitioner and expert community of 80K+ members, ready to discover, help and collaborate together while making meaningful connections.
Click here to register and join today!
Engage in exciting technical discussions, join a group with your peers and meet our Featured Members.