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
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
Use ALTER TABLE
https://www.lianja.com/doc/index.php...umn_Constraint
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
Thanks, figure it out
Code:alter table Scrapbinweights alter constraint(RecID autoinc nextvalue 41 step 1)
Posting Permissions
Reply With Quote
Bookmarks