I have an existing table called Persion. In this table I have 5 columns:
PersionId and Pname were the primary keys I chose for this table when I was creating it.
I now want to add PMID as a new column to the primary key. How do I construct this in an ALTER statement? (The table already contains 1000 records.)
Can someone help me with this?