Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Create FK

Author  Topic 

shapper
Constraint Violating Yak Guru

450 Posts

Posted - 2007-01-31 : 19:38:36
This is a really basic question but how to I create a relationship between two tables using the Microsoft SQL 2005 Management Studio?

I have created the two tables but I can't find where to create the relationship.

Thanks,
Miguel

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2007-01-31 : 21:52:00
Using the Object Explorer, go to your table, under Keys, right click 'New Foreign Key ...'


KH

Go to Top of Page
   

- Advertisement -