Is it possible to make a SQLServer table's PK column to be indentity after the table is populated?

That would depend on the version of SQL Server that you're running.

On 2008 and older, no.

I'm using 2014, could you point the command (or a reference to it) ?

As far as I know, there is no magic one-line command.  But you can still do it.  If there are no foreign keys that reference that column, the easiest is to

ALTER TABLE {mytable} ADD {newcolumn} INT IDENTITY(1,1) NOT NULL;

Copy the values in the PK to the new column.
Drop the old PK column.
Rename the new column to the same name as the dropped column.

If there are foreign keys against the table, it gets a lot more involved.

Hi

Going the easyest way


It's not possible to update the identity column with the old values...

Set IDENTITY_INSERT ON

and you should be able to update the row to have the values in the original row.

Remember to set IDENTITY_INSERT OFF again when you're done!  :)

Even doing that

I believe that you'll need to run both statements together.  Highlight them and run them in a single step.

Since I'm doing a migration data that must preserve the table codes, I have to go this way... just a little more time...

Also remember that this will affect any foreign keys that are in place.  You'll have to reestablish them.

Really a good solution the 2nd option you give.

Thanks for the guidance!