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.
| 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 |
|
|
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? |
 |
|
|
|
|
|