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
 Help! Can't find the Relationships

Author  Topic 

silas2
Yak Posting Veteran

65 Posts

Posted - 2007-03-20 : 14:03:32
I'm using SQL Express with the Management Studio. I create a database diagram, and add a relationship. The relationship is shown in the diagram, but if I right-click it, I only get the option to delete it, I can't see it's properties.
When I go thru the nodes for all the objects in the Object Explorer where I think I should be able to find this relationship, I can't find it???
I look in Triggers/Constraints both for the database as a whole and for the individual participating tables but I can't see the relationship anywhere.
What am I doing wrong? Where should I be looking?

X002548
Not Just a Number

15586 Posts

Posted - 2007-03-20 : 14:13:02
Could it be that SSMS is making a pretty diagram and not doing anything?

ALTER TABLE....



Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Add yourself!
http://www.frappr.com/sqlteam



Go to Top of Page

silas2
Yak Posting Veteran

65 Posts

Posted - 2007-03-20 : 14:35:32
You think adding the relationships thru sql is the best way?
Is a relationship a Trigger or a Constraint?
Go to Top of Page
   

- Advertisement -