Results 1 to 3 of 3

Thread: AutoInc Reseed

  1. #1
    Junior Member
    Join Date
    Jan 2020
    Posts
    7

    AutoInc Reseed

    Is there a way reset the auto-increment value for an autoinc field?

    like:
    Code:
    delete from JobCost
    go
    
    DBCC CHECKIDENT('JobCost', reseed, 0)
    go

  2. #2
    Lianja Development Team barrymavin's Avatar
    Join Date
    Feb 2012
    Location
    UK, USA, Thailand
    Posts
    5,778
    Principal developer of Lianja, Recital and other products

    Follow me on:

    Twitter: http://twitter.com/lianjaInc
    Facebook: http://www.facebook.com/LianjaInc
    LinkedIn: http://www.linkedin.com/in/barrymavin

  3. #3
    Junior Member
    Join Date
    Jan 2020
    Posts
    7
    Thanks, figure it out

    Code:
    alter table Scrapbinweights alter constraint(RecID autoinc nextvalue 41 step 1)

Bookmarks

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Journey into the Cloud
Join us