How can reset identity seeding in SQL on ID column ?

Posted by  Sanat Shukla
 900  View(s)
Ratings:
Rate this:

Reset identity seeding in SQL  server on ID column Where ID column is auto increment.

And don't use the drop, delete or truncate command on That table.

  1. Re: How can reset identity seeding in SQL on ID column ?

    DBCC CHECKIDENT ('[TestTable]', RESEED, 0);

    GO

    Hope it'll help you.

Answer