Reset the main key column with existing information in SQL Server 2008?

I have an existing table where the first couple of rows have actually been removed. Is it feasible to reset the main key so the existing information Id column adjustments back to 1,2,3.?

0
2019-05-07 09:01:17
Source Share
Answers: 3

This need to function : DBCC CHECKIDENT (tableName, RESEED, 0). The pointer is from here

0
2019-05-09 03:35:51
Source

I assume this inquiry comes from SO.

As an example you might locate renumber primary key handy

0
2019-05-09 02:51:25
Source