cancel
Showing results for 
Search instead for 
Did you mean: 
Data Engineering
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Bittu6084
New Contributor II

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

1 ACCEPTED SOLUTION

Accepted Solutions

Hubert-Dudek
Esteemed Contributor III

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

View solution in original post

6 REPLIES 6

-werners-
Esteemed Contributor III

@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
Esteemed Contributor III

@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
Community Manager
Community Manager

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
Community Manager
Community Manager

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

QPeiran
New Contributor III

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

Kaniz
Community Manager
Community Manager

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

Please read the article here.

Welcome to Databricks Community: Lets learn, network and celebrate together

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.