How can reset identity seeding in SQL on ID column ?

Total Post:58

Points:408
 480  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. Post:281

    Points:2003
    Re: How can reset identity seeding in SQL on ID column ?

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

    GO

    Hope it'll help you.

Answer