Alter table to create primary key, on two fields

[Blorf]

Hi. Need syntax help.

I have a table called "ExtdDesc_Local" with 3 fields,

ItemNumber
SEQNumber
Text

I need to alter the table to have the primary key be on ItemNumber & SEQNumber.

I need a Query to do it, because it will be run often when this table is created with a make table statement.

I appreciate any help,
ChaZ

There Are 10 Types Of People In The world:
Those That Understand BINARY And Those That Don’t.

 

[rac2]

Maybe

ALTER TABLE MyTable
ADD CONSTRAINT pk_Item_Seq_Numbers
PRIMARY KEY (ItemNumber, SEQNumber)