The last modifications of this post were around 1 year ago, some information may be outdated!
Summary
Reset an auto-incrementing columns in a table.
Code
DBCC CHECKIDENT (TABLE_NAME, RESEED, 0)Reset an auto-incrementing columns in a table.
DBCC CHECKIDENT (TABLE_NAME, RESEED, 0)