How do i create relationships in MS SQL Server

Posted on 2006-05-16
Last Modified: 2006-11-18
1. How do i create relationships in MS SQL Server?

2. After doing so, do i need to create relationships again in the my
Typed Datasets, .xsd

3. How do i ensure my VS.NET 2003 knows these relationships exists
Question by:jedistar
    LVL 142

    Expert Comment

    by:Guy Hengel [angelIII / a3]
    1. this is technically done using FOREIGN KEY constraints. if you are looking for the visualization, use the database diagram


    Author Comment

    How do i create the fkey contraints
    LVL 142

    Accepted Solution

    LVL 3

    Expert Comment

    You can create relationships between your tables to show how the columns in one table are linked to columns in another table

    This would help you. :-

    Bharat Butani.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    This is my first ever Article on EE or elsewhere; therefore, please bear with me if I have some discrepancies in my writing. I read many articles and questions related to "how to pass values to SSIS packages at run-time?"  Hence, this common ques…
    Having an SQL database can be a big investment for a small company. Hardware, setup and of course, the price of software all add up to a big bill that some companies may not be able to absorb.  Luckily, there is a free version SQL Express, but does …
    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
    Via a live example, show how to setup several different housekeeping processes for a SQL Server.

    759 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

    9 Experts available now in Live!

    Get 1:1 Help Now