View Foreign Key Constraint Attributes

View the foreign key attributes of a relationship if you want to see which columns participate in the foreign key side of a relationship. If the foreign key columns are related to a primary key, the primary key columns are identified in your database diagram by a primary key symbol in the row selector .

1. In the Database window, click Database Diagrams   under Objects, click the database diagram you want to open, and then click Design on the Database window toolbar.
2. In your database diagram, right-click the relationship line corresponding to the foreign key, then choose Properties from the shortcut menu.
3. Choose the Relationships tab.
4. Make sure the relationship is selected in the Selected relationship list.
5. The Foreign key table column displays the name of each column that participates in the foreign key side of the relationship.