• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 316
  • Last Modified:

How do i create relationships in MS SQL Server

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
  • 2
1 Solution
Guy Hengel [angelIII / a3]Billing EngineerCommented:
1. this is technically done using FOREIGN KEY constraints. if you are looking for the visualization, use the database diagram

jedistarAuthor Commented:
How do i create the fkey contraints
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. :- http://msdn2.microsoft.com/en-us/library/ms189049.aspx

Bharat Butani.

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

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.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now