Hello
if i have afield primary key , auto number, it usually starts with 1 , how to make it start with 0 ?
regards
make AutoNumber start from Zero
-
- BronzeLounger
- Posts: 1227
- Joined: 01 May 2016, 09:58
-
- Administrator
- Posts: 78488
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: make AutoNumber start from Zero
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.
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
Hans
-
- BronzeLounger
- Posts: 1227
- Joined: 01 May 2016, 09:58