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

Solutions


Junaid A

i really need this solution thanks

Your Answer

10318