How can we alter table with auto increment column for a delta table

[Bittu6084]

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

[-werners-]

@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.

[Hubert-Dudek · Accepted solution]

@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.

[Kaniz]

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.

[Kaniz]

Hi @Bittu6084 (Customer)​ , Just a friendly follow-up. Do you still need help?

[QPeiran]

Hi, I have the same concern. What's the best way to achieve this?

[Kaniz]

Hi @Peiran Quan​, This option is only supported for identity columns on Delta Lake tables.

Please read the article here.