How can reset identity seeding in SQL on ID column ?

Total Post:24

Points:170
 381  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:280

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

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

    GO

    Hope it'll help you.

Answer

NEWSLETTER

Enter your email address here always to be updated. We promise not to spam!