Hi Team,
I need to empty a Jobtickets table and reset the autoinc field, 'JobNo' back to 0 so the first record added is 1.
I have looked at the few 'examples' in the forums but am still not sure what to code in SQL.
Pls advise.

Regards & TIA,
Ian

Hi Ian,

Tim has a FAQ on this at https://www.elevatesoft.com/supportfaq?action=view&category=edb&question=altering_identity_seed_value

Hi Terry,
Ahhh. Tks, I didn't read down far enough-(

>> ALTER COLUMN MyIdentityColumn RESTART WITH <NewSeedValue>

<NewSeedValue>?  If I set that to 1, does that mean the next (first) record added will be # 1?

Ian

Ian


><NewSeedValue>? If I set that to 1, does that mean the next (first) record added will be # 1?

WIthout actually trying it the last paragraph

<<This statement will properly reset the seed value for the IDENTITY column so that any newly-inserted rows will use the new seed value.>>

makes me think so

Toy

><NewSeedValue>? If I set that to 1, does that mean the next (first) record added will be # 1?

If you set the SeedValue to 1, the next generated number will be 2.

Terry

Terry


You are right. I should have looked at how Tim has set it up in the create table dialog

Roy Lambert

>Hi Team,
>I need to empty a Jobtickets table and reset the autoinc field, 'JobNo' back to 0 so the first record added is 1.
>I have looked at the few 'examples' in the forums but am still not sure what to code in SQL.
>Pls advise.

I believe EMPTY TABLE <TableName> will so what you are looking for.

https://www.elevatesoft.com/manual?action=viewtopic&id=edb2sql&topic=EMPTY_TABLE

Michael Riley
GySgt USMC (Retired)
www.zilchworks.com