auto number through Query 3

[aatif]

How can I create a field in a table with data type auto number,

e.g.
create table docUsers (id number, login text(25), password text(25), level number, constraint doc_pk primary key ([id]) )

In this query I want to change the data type of id to autonumber, how can I achieve that.

Thanx
Aatif Malik

 

[dalchri]

Try the following:
[tt]
CREATE TABLE docUsers (
id Counter,
login text(25),
password text(25),
level number,
constraint doc_pk primary key ([id])
)
[/tt]