Is there a way to manually change/update an ID number in SQL Server Management Studio
Posted on 2010-11-18
The ID number are auto-incremental and some rows were deleted so there are numbers in between where there are a couple of instances were I would like to change one or two of those ID numbers for continuity but is grayed out. Is there a way to do this with the GUI interface?
For example I have rows
I would like to change the 4 to a 2 and the 5 to a 3.
ID is the primary key and is set to "identity".
Thank you in advance.