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.
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.