April 13, 2012

DROP Primary Key Constraint

How can we delete primary key from a table?
Using DROP CONSTRAINT we can do the same.


ALTER
TABLE <Table Name>

DROP CONSTRAINT <Primary Key Constraint Name>


That's It.
Enjoy Learning.
 

No comments:

Post a Comment