Export (0) Print
Expand All

Tables and Columns Dialog Box

Updated: March 12, 2009

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.

 

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.

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

Community Additions

ADD
Show:
© 2014 Microsoft