Creating DB Tables using SQL

[rodders45]

Does anyone know how to create a table in an Access database using SQL, creating a primary key field which increments automatically?

[RogerH]

CREATE TABLE Test (ID AutoIncrement Constraint PrimaryKey PRIMARY KEY, OtherField TEXT);

Roger

[rodders45]

Thanks a lot

Incidentally...

That's called DDL (data manipulation language - a subset of SQL) the other one is DML (data manipulation language - SELECT and all that lark)

Geek signing off!