Export (0) Print
Expand All

Foreign Key Relationships Dialog Box

Updated: March 12, 2009

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.

 

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.

noteNote
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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft