Create Table Query (SQL)

[Kevin O'Shea]

Anyone know how to define a Data Type as AutoNumber in a
create table query done in SQL. I can define as text,
currency, etc. but the program won't accept autonumber.
Here is sample of code:

CREATE TABLE RANKTEMP
([RANK] number,
[ID] number,
[Building Number] text,
[Cost] currency,
......

I am trying to get it to apply a [RANK] as an autonumber.
Thanks in advance for any help.

 

[Dan Artuso]

Hi,
I believe the correct word is:
Autoincrement. "Counter" will also work in Access
CREATE TABLE Code3 (
ID AUTOINCREMENT,
Account TEXT(50),
Code MEMO,
Active Bit,
Hits int,
Rotation int
)