troubleshooting Question

Quick 500 - SQL 2005 - ALTER TABLE to add another primary key constraint?

Avatar of Gweep
Gweep asked on
Microsoft SQL Server
4 Comments1 Solution5733 ViewsLast Modified:
Hi Experts,

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
Database Consultant
Join our community to see this answer!
Unlock 1 Answer and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros