sql-serveridentity

How do I reset an increment identity's starting value in SQL Server


I would like to have a nice template for doing this in development. How do I reset an increment identity's starting value in SQL Server?


Solution

  • DBCC CHECKIDENT('TableName', RESEED, 0)