Reset identity seed records in SQL Server
Ask Question
By
Junaid A
25-Apr-2024
2
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);
Jack Carter
2 hours agoi think that some how, we learn who we really are and then live with that decision, great post!
you can view the more detail via link https://www.youtube.com/watch?v=HpZgwHU1GcIChing xang
2 hours agoi think that some how, we learn who we really are and then live with that decision, great post!
Danial Comb
2 hours agoi think that some how, we learn who we really are and then live with that decision, great post!
Jack Carter
2 hours agoi think that some how, we learn who we really are and then live with that decision, great post!