[RESOLVED] Multiple Primmary Keys

[slindstr]

Hey everyone I have a fairly simple question: how do I declare a compound primary key using MS SQL Server 2000? I'm used to the MYSQL syntax...

it doesn't seem to like:

CREATE TABLE PARTSUPP(
PS_PARTKEY integer primary key references PART(P_PARTKEY),
PS_SUPPKEY integer primary key references SUPPLIER(S_SUPPKEY),
PS_AVAILQTY integer,
PS_SUPPLYCOST decimal(12,2),
PS_COMMENT varchar(199)

)

The error i get is :
Cannot add multiple PRIMARY KEY constraints to table 'PARTSUPP'.

Thanks in advance
Steve

[barand]

CREATE TABLE PARTSUPP(
PS_PARTKEY integer foreign key references PART(P_PARTKEY),
PS_SUPPKEY integer foreign key references SUPPLIER(S_SUPPKEY),
PS_AVAILQTY integer,
PS_SUPPLYCOST decimal(12,2),
PS_COMMENT varchar(199),
PRIMARY KEY (PS_PARTKEY, PS_SUPPKEY)
)

[slindstr]

Thanks a bunch - it worked great!