Can we modify the constraint of a primary key in an existed table?

jeremy98 — Wed, 18 Dec 2024 09:52:29 GMT

Hello Community,

Is it possible to modify the schema of an existing table that currently has an ID column without any constraints? I would like to update the schema to make the ID column a primary key with auto-increment starting by the maximum id already present in the existed table. Is recreating the schema the only way to achieve this?

Re: Can we modify the constraint of a primary key in an existed table?

PiotrMi — Wed, 18 Dec 2024 10:27:52 GMT

Hey @jeremy98

Based on some old article it looks it cannot be done:

There are a few caveats you should keep in mind when adopting this new feature. Identity columns cannot be added to existing tables; the tables will need to be recreated with the new identity column added. To do this, simply create a new table DDL with the identity column, and insert the existing columns into the new table, and surrogate keys will be generated for the new table.

I think recreate and copy data will be the ea

topic Can we modify the constraint of a primary key in an existed table? in Data Engineering

Can we modify the constraint of a primary key in an existed table?

Re: Can we modify the constraint of a primary key in an existed table?