Reset Identity Column value SQL Server
DBCC CHECKIDENT (tableName, RESEED, 10) Note that the next value will be whatever you reseed with + 1, so in this case I set it to 10 so that the next value will be 11.