How to Reseed the Identity to 0 in Mssql
There are times when you want to reset the identity back to 0 before inserting records into the database. To do that execute the following s...
https://www.czetsuyatech.com/2021/07/mssql-reseed-identity-to-zero.html
There are times when you want to reset the identity back to 0 before inserting records into the database.
To do that execute the following script on master database:
dbcc checkident('TableName', RESEED,0)
To do that execute the following script on master database:
dbcc checkident('TableName', RESEED,0)
Post a Comment