Auto update primary key ID after deleting record in SQL Server

Hi George616,

Is the ID column is an Identity column?

Do you set ID as IDENTITY?

Also what you are trying to do is dangerous, as this is a PRIMARY KEY Column.

Example

If your ID column is referenced in other table then the data displays wrong while you reference the data.

Form my suggestions keep the id as it is. Don't change it.