m-u
9/25/2013 - 1:47 PM

Reset Identity Column value SQL Server

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.