Export (0) Print
Expand All

Viewing Foreign Key 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.

To view the foreign key attributes of a relationship

  1. In your database diagram, right-click the relationship line corresponding to the foreign key, then choose Properties from the shortcut menu.

    -or-

    Open the Table Designer for the table containing the foreign key you want to modify, right-click in the Table Designer, and choose Properties from the shortcut menu.

  2. Choose the Relationships tab.

  3. Make sure the relationship is selected in the Selected relationship list.

  4. The Foreign key table column displays the name of each column that participates in the foreign key side of the relationship.

See Also

Constraints | Foreign Key Constraints | Modifying a Foreign Key

Show:
© 2014 Microsoft