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