?
Solved

Multiple primary keys via gui

Posted on 2012-12-28
2
Medium Priority
?
324 Views
Last Modified: 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

mult prim keys
0
Comment
Question by:Tom Knowlton
[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
 
LVL 69

Accepted Solution

by:
Scott Pletcher earned 2000 total points
ID: 38728229
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 :-) .
0
 
LVL 5

Author Closing Comment

by:Tom Knowlton
ID: 38728233
Thanks!
0

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This is basically a blog post I wrote recently. I've found that SARGability is poorly understood, and since many people don't read blogs, I figured I'd post it here as an article. SARGable is an adjective in SQL that means that an item can be fou…
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…
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
In this video, Percona Director of Solution Engineering Jon Tobin discusses the function and features of Percona Server for MongoDB. How Percona can help Percona can help you determine if Percona Server for MongoDB is the right solution for …

801 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question