Creating tables from SQL view

[Guest]

Hello everyone

I am using SQL view of query to create my tables. Appreciate your help with
my questions :

1. How do I create a table with composite primary key ? I have created one
with 1 key, but how can I create them with 2 primary keys? Could you tell me
the syntax?

2. I want to create a table which has fields of type boolean and autonumber,
how should I code that ? I tried to put type of fields as yes/no (and
true/false) and autonumber , but I got errors.


Thank you in advance
Evrim

 

[Allen Browne]

See:
DDL Code Examples
at:
http://allenbrowne.com/func-DDL.html#CreateTableDDL

The example shows how to create a Counter field as well as the other types,
and also a unique index based on 2 fields.