Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How do you set relations in sql for tables Expand / Collapse
Author
Message
Posted Sunday, October 21, 2012 10:20 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Friday, July 12, 2013 7:25 AM
Points: 39, Visits: 144
I have several tables and need to set relationships. How do you do this with the sql server manager?

Thanks Lon
Post #1375180
Posted Sunday, October 21, 2012 12:36 PM


SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Saturday, July 12, 2014 10:27 AM
Points: 91, Visits: 163,829
lonhanner (10/21/2012)
I have several tables and need to set relationships. How do you do this with the sql server manager?


Here is an article on creating foreign key relationships in SQL Server

This contains instructions for how to setup this type of key in SSMS (or SQL Data Tools), or through DDL SQL commands. If you have a specific scenario then please feel free to post it for someone to help you.


-----------------
... Then again, I could be totally wrong! Check the answer.
Check out posting guidelines here for faster more precise answers.

I believe in Codd
... and Thinknook is my Chamber of Understanding
Post #1375197
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse