How to add IDENTITY/AUTO_INCREMENT in a existing table?

iddpanganiban

We are moving data from the old server to the new server.

SruthiA

@iddpanganiban you cannot add identity columns to existing tables. Only way to add them is recreate the table with identity column, copy the data to new table and drop old table.