Tables and Columns Dialog Box
Applies To: Windows Server 2008, Windows Server 2008 R2
Use the Tables and Columns dialog box to specify the tables and columns to use in your foreign key relationship.
UI Elements
| Element Name | Description |
|---|---|
Relationship name |
Type a name to identify the foreign key relationship. For example, if you are creating a foreign key relationship on the ContosoUsers table from the AccessControls table, you might type FK_AccessControlsForUsers. |
Primary Key Table |
Select the table that you want to use to specify the primary key from the drop-down list. |
Foreign Key Table |
Select the table that you want to use to specify the foreign key from the drop-down list. |
Primary key |
Select the primary key from the drop-down list below the Primary Key Table drop-down list. The primary key will be linked to the foreign key that you specify in the foreign key drop-down list. |
Foreign key |
Select the foreign key from the drop-down list below the Foreign Key Table drop-down list. The foreign key will be linked to the primary key that you have specified in the primary key drop-down list. |