Create table and fields using SQL 1

[toyt78]

How do I create an Access 2000 table and fields using SQL?

My attempt for creating a new table called newTable with a primary key of table_id and two more fields called firstname and theNumber:

create table newTable
(table_id integer not null unique autonumber,
firstName text(12),
theNumber integer));

Please advise if this is okay?

 

[PHV]

You may try this:
create table newTable (
table_id counter(1,1) primary key,
firstName text(12),
theNumber integer
);

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[toyt78]

Thanks