How do you set relations in sql for tables

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » How do you set relations in sql for tables

How do you set relations in sql for tables

Rate Topic

Display Mode

Topic Options

Author

Message

lonhanner

Posted Sunday, October 21, 2012 10:20 AM

SSC Rookie

Group: General Forum Members
Last Login: Friday, February 22, 2013 11:14 AM
Points: 39, Visits: 141

I have several tables and need to set relationships. How do you do this with the sql server manager?

Thanks Lon

Post #1375180

ib.naji

Posted Sunday, October 21, 2012 12:36 PM

SSC Journeyman

Group: General Forum Members
Last Login: Today @ 9:37 PM
Points: 91, Visits: 108,462

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 »

Permissions