Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action.
Course Of The Month
6 days, 11 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
Multiple primary keys via gui
Posted on 2012-12-28
How do you setup multiple primary keys for a table?
I can only get it to set ONE primary key at a time. If I try to set some other column to be a primary key it marks that column as the primary key and undoes the other one.
for example,
AgentFormOverrideID is the primary key
And I want to also set:
AgentFormOverrideSID as a part of the primary key
I can only get it to set ONE primary key at a time. If I try to set some other column to be a primary key it marks that column as the primary key and undoes the other one.
for example,
AgentFormOverrideID is the primary key
And I want to also set:
AgentFormOverrideSID as a part of the primary key
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
2 Comments
Active 1 day ago
Designate the first PK column thru the GUI, as you've done.
Then right-click on the column; select "Indexes/Keys"; click on the "..." after the "Columns"; in the (empty) second line, add the key column you need; click "OK".
Then exit design, doing a "Save" when asked :-) .
Then right-click on the column; select "Indexes/Keys"; click on the "..." after the "Columns"; in the (empty) second line, add the key column you need; click "OK".
Then exit design, doing a "Save" when asked :-) .
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
There have been several questions about Large Transaction Log Files in SQL Server 2008, and how to get rid of them when disk space has become critical. This article will explain how to disable full recovery and implement simple recovery that carries…
Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
There's a multitude of different network monitoring solutions out there, and you're probably wondering what makes NetCrunch so special.
It's completely agentless, but does let you create an agent, if you desire.
It offers powerful scalability …
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
Suggested Courses
Course of the Month6 days, 11 hours left to enroll
Earn Certification
Administering Microsoft SQL Server 2012 Databases (Exam 70-462)
$79.00$71.10
726 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.