Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


foreign keys

Posted on 2005-04-20
Medium Priority
Last Modified: 2010-03-19
Quick question, in MS SQL Server enterprise manager, how can I create a foreign key constraint on one or more of the attributes of a table?  Thanks.
Question by:ARACK04
  • 2
LVL 28

Accepted Solution

rafrancisco earned 500 total points
ID: 13828413
Go to Design Table, click on Relationships and click New.  You can select multiple columns from this and not just one.

Assisted Solution

obahat earned 500 total points
ID: 13828414
Goto the tables listing, rightclick --> design table --> goto the relationship/references tab.
(don't have exact name for the tab, Just installed Yukon and my console is down) :).


Author Comment

ID: 13828606
I'm using one computer with Version 5.0 and another with 5.2, and I don't see a way to do what you said on either.  

Author Comment

ID: 13828657
Got it, you have to create a new diagram, and do it that way.  Thanks!

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

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

An alternative to the "For XML" way of pivoting and concatenating result sets into strings, and an easy introduction to "common table expressions" (CTEs). Being someone who is always looking for alternatives to "work your data", I came across this …
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Via a live example, show how to extract insert data into a SQL Server database table using the Import/Export option and Bulk Insert.
Suggested Courses

580 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