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

---

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)

---