make AutoNumber start from Zero

siamandm
BronzeLounger
Posts: 1227
Joined: 01 May 2016, 09:58

make AutoNumber start from Zero

Post by siamandm »

Hello

if i have afield primary key , auto number, it usually starts with 1 , how to make it start with 0 ?

regards

User avatar
HansV
Administrator
Posts: 78488
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: make AutoNumber start from Zero

Post by HansV »

An AutoNumber field is intended as a unique but meaningless identifier. So it shouldn't matter whether it starts with 0 or with 1.
But if you wish, you can execute a query with the following SQL:

ALTER TABLE TableName ALTER COLUMN FieldName COUNTER(0,1)

Warning: I haven't tried it myself.
Best wishes,
Hans

siamandm
BronzeLounger
Posts: 1227
Joined: 01 May 2016, 09:58

Re: make AutoNumber start from Zero

Post by siamandm »

thanks a lot,