In my previous post I just explain how to create primary key with multiple columns, now I just explain how to alter the primary key columns.
EX:
ALTER TABLE Products
DROP CONSTRAINT PK_Products
GO
Now, we need to Alter the primary key columns with the help of ALTER statement.
EX:
ALTER TABLE Products
ADD PRIMARY KEY (Prod1, Prod2);
GO