This is a daunting task, because I have never done it before and don't want to seriously break anything. Basically I have a table with on primary key. I need to change the table to have a composite primary key. So do I first remove the primary key constraint and then proceed from their? I can do it through the GUI. It would be nice to know how to do it through sql though. Can anyone give me some guidance/help?
View Complete Post