Access 2000 - Create Table script (for composite key)

S

Sachin D. Rajhans

I want to write SQL DDL script for creating a table having
primary key on two fields(composite key) in Access 2000.
I could find the Create Table for single primary key but
not for composite key.

table structure is,

Create Table SelectionList
(
ResourceId Long, (PK)
TypeId Text(1),
EmployeeId Text(8), (PK)
Title Text(200)
)


Please, if any body have knowledge about this then send me
e-mail on '(e-mail address removed)' this ID.

Regards,
Sachin.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top