topic How can we alter table with auto increment column for a delta table in Data Engineering

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

Bittu6084 — Wed, 04 May 2022 12:00:20 GMT

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- — Fri, 06 May 2022 06:28:59 GMT

@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 — Sat, 07 May 2022 11:11:28 GMT

@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 — Wed, 22 Jun 2022 03:13:47 GMT

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