How to Alter the table relationships.?

Naveenhcl
Posted by Naveenhcl under Sql Server category on | Points: 40 | Views : 294
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

Comments or Responses

Login to post response