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, select a relationship line.
   
   
2. Right-click the table and select Properties.
   
   
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.