Take the tour ×  I have an existing table where the first few
rows have been deleted. Is is possible to reset the primary key
so the existing data Id column changes back to 1,2,3..?
share|improve this question I think you should post it on
StackOverflow –  kristof Apr 30 '09 at 10:52 add comment  3
Answers  up vote 3 down vote accepted  I think this question
belongs to SO.  For example you may find renumber primary key
helpful  share|improve this answer add comment  This should
work: DBCC CHECKIDENT(tableName, RESEED, 0). The tip is from
here  share|improve this answer add comment  Your Answer