Monday, April 15, 2024

How do you reset the identity start value in SQL Server?

TRUNCATE TABLE YourTableName; -- Delete all records 

DBCC CHECKIDENT ('YourTableName', RESEED, 1); -- Reset identity column