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

jeremy98
Honored Contributor

 

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?