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.

[QPeiran]

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