Reset identity seed records in SQL Server
How to Reset identity seed records in SQL Server?
Option1
DBCC CHECKIDENT ('[YourTableName]', RESEED, 0);
GO
Option 2
DBCC CHECKIDENT ('NameofYourTable', RESEED, 0)
GO
'Option 3
DELETE FROM [MyTable];
DBCC CHECKIDENT ('[MyTable]', RESEED, 0);
By Junaid A 19-Jan-2023 2