foreign keys

Posted on 2005-04-20
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
    LVL 28

    Accepted Solution

    Go to Design Table, click on Relationships and click New.  You can select multiple columns from this and not just one.
    LVL 5

    Assisted Solution

    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

    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

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

    Featured Post

    Enabling OSINT in Activity Based Intelligence

    Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

    Join & Write a Comment

    In this article—a derivative of my blog post (—I will explore a few different perspectives on which week today's date falls within using Microsoft SQL Server. First, to frame this stu…
    This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
    This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
    Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

    746 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

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now