I have a table in SQL 2005 with 5 existing primary keys, to add in some extra fuinctionality i need to add a sixth primary key to the table.
The only problem is that every time i try and do it via the GUI, i get a timeout ... i've done some googling and apparently i need to script the change ... except i can't find anything about using the ALTER TABLE command to add a sixth primary key.
Can anyone tell me the correct ALTER command to add a sixth primary key to my table?
I have already set the column to not allow nulls btw.
Thanks in advance