Plaease! Creating a table with unique index

[Luke71]

I'm writing a C# program which creates a MS Access database by "Create table..."
Can you tell me how creating an index as primary key? It should be an automatic indexer, updating itself if I delete a record or I insert a new one..which syntax should I use?
Thanks,
Luke

 

[mp9]

CREATE TABLE in Jet SQL takes the form:

CREATE [TEMPORARY] TABLE table (field1 type [(size)] [NOT NULL] [WITH COMPRESSION | WITH COMP] [index1] [, field2 type [(size)] [NOT NULL] [index2] [, ...]] [, CONSTRAINT multifieldindex [, ...]])


Alternatively there's also the CREATE INDEX statement which takes the form:

CREATE [ UNIQUE ] INDEX index
ON table (field [ASC|DESC][, field [ASC|DESC], ...])
[WITH { PRIMARY | DISALLOW NULL | IGNORE NULL }]

Hope this helps.

http://www22.brinkster.com/accessory/