Reset autoincrement to start at 1 in Microsoft SQL Server

Use the following command to reseed YourTableNameHere to start at 1:

DBCC CHECKIDENT (YourTableNameHere, RESEED, 0)

Leave a Reply