Reseed the Identity field in ms sql server
- By Junaid A March-02-2023
- 257
DBCC checkident (Customer, RESEED, 3)
Reseed the Identity field
You can also reseed the identity field value. By doing so identity field values will start with a new defined value.
Suppose you want to reseed the Customer table ID field from 3 then the new record s will be inserted with ID 4,5,6..and so on.
--Reseeding the identity
DBCC checkident (tbluser, RESEED, 3)
INSERT INTO tbluser(Name,Address) VALUES('Geeta','Noida')
Reset autoincrement value from specific value
Reset Identity column value
