no

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...

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)

Related

rdbms 6379584877411284360

Post a Comment Default Comments

Outsourcing

Are you looking for freelancers in the Philippines? Get in touch.

Donations

If you like what I do, you can support this channel by buying me a coffee. I would be grateful for your contribution! Your donations will help me create more FREE online courses and learning materials for programmers and remote workers.

item