Solved

Multiple primary keys via gui

Posted on 2012-12-28
2
319 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:knowlton
2 Comments
 
LVL 69

Accepted Solution

by:
Scott Pletcher earned 500 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:knowlton
ID: 38728233
Thanks!
0

Featured Post

Efficient way to get backups off site to Azure

This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.

Question has a verified solution.

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

Suggested Solutions

I have written a PowerShell script to "walk" the security structure of each SQL instance to find:         Each Login (Windows or SQL)             * Its Server Roles             * Every database to which the login is mapped             * The associated "Database User" for this …
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

831 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