How to: Show Relationship Properties (Visual Database Tools)
You can display properties for a relationship in the Foreign Key Relationships dialog box in the Table Designer.
To show relationship properties in the Properties window
In Object Explorer, right-click the table you want to open and click Design (Modify in SP1 or earlier).
The table opens in Table Designer.
From the Table Designer menu, click Relationships.
In the Foreign Key Relationships dialog box, select the relationship with properties you want to view.
The properties are displayed in the grid.
See Also
Tasks
How to: View Foreign Key Properties (Visual Database Tools)
Other Resources
Working with Relationships (Visual Database Tools)