>hi all,
>
>can someone show me a simple SQL statment to create a table with 2 primary keys?
>
>thanks a lot!
>Jimi
You can't create a table with two primary keys, only one per table is allowed. What you can do is create a candidate key (field with a candidate index), which functions in a similar way as a primary key. A sample statement to do that would be:
CREATE TABLE mypktest (iid i PRIMARY KEY, ssn c(10) UNIQUE)
Uniqueness is enforced on both a primary key and a candidate key. HTH