To check the identity value:
DBCC
CHECKIDENT ('Tablename',
NORESEED)
To reset the identity value to the next starting value:
If we give the number as 20,It will reset the identity value to\from 21
DBCC
CHECKIDENT ('Tablename',
RESEED, 20)
No comments:
Post a Comment