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
Printable View
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
Thanks, figure it out
Code:alter table Scrapbinweights alter constraint(RecID autoinc nextvalue 41 step 1)