Sqlserver question

[tkdkid]

I have a table, 'Options', and am trying to change the primary key from just productID to productID and productCode. I don't have enterprise manager available here so I'll have to do it using the alter table command. I tried 'alter table primary key (productID,productCode)' but I get an error - syntax error near 'primary'.

Does anyone know how to do this?

 

[tkdkid]

Nevermind. I was finally able to put the pieces together.