Foreign Key Relationships Dialog Box

  • Article

Applies To: Windows Server 2008, Windows Server 2008 R2

Use the Foreign Key Relationships dialog box to add a foreign key relationship and specify the properties for the relationship, including setting the name, foreign key table, and primary key table.

UI Elements

Element Name Description

Add

Adds a foreign key relationship, and displays the foreign key properties in the right pane.

Delete

Deletes the selected foreign key relationship. You will not receive a confirmation before the foreign key relationship is deleted.

Close

Closes the Foreign Key Relationships dialog box.

Tables and Columns Specification

Opens the Tables and Columns dialog box for you to specify the relationship name, the primary key and foreign key tables, and the primary and foreign keys. For more information, see Tables and Columns Dialog Box.

Foreign Key Base Table

Displays the foreign key table that you specified in the Tables and Columns dialog box. This value is read-only.

Note
If you are creating a table and have not yet saved the table, this field will remain blank until you have saved the table.

Foreign Key Columns

Displays the foreign key column that you specified in the Tables and Columns dialog box. This value is read-only.

Primary Key Base Table

Displays the primary key table that you specified in the Tables and Columns dialog box. This value is read-only.

Primary Key Columns

Displays the primary key that you specified in the Tables and Columns dialog box. This value is read-only.

(Name)

Type a name for the foreign key relationship. For example, if your table is called ContosoUsers, you might type FK_ContosoUsers.