How can reset identity seeding in SQL on ID column ?

Total Post:87

Points:615
 692  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:286

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

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

    GO

    Hope it'll help you.

Answer

Please check, If you want to make this post sponsored

You are not a Sponsored Member. Click Here to Subscribe the Membership.