How to: Create Matching Foreign and Primary Keys
When you copy a column from one table to another table, the column name and many of the other properties you defined for that column in the original table are copied to the new location. You can copy column properties from a primary key column to a foreign key column if you want to relate the two columns. Related columns must have the same data type (or data types that can be related) and length.
Note
The dialog boxes and menu commands you see might differ from those described in Help depending on your active settings or edition. To change your settings, choose Import and Export Settings on the Tools menu. For more information, see Visual Studio Settings.
To copy primary key columns to foreign key columns
In Server Explorer, right-click the table with primary key columns you want to copy and click Open Table Definition. Do the same for the table into which you want to copy the columns as foreign keys.
The tables open in Table Designer.
Click the tab for the table with the columns you want to copy.
Select the primary key columns that you want to copy.
Primary key columns are indicated by a key symbol in their row selector.
From the Edit menu, click Copy.
Click the tab for the table into which you want to copy the columns.
Select the column you want to follow the inserted columns and from the Edit menu, click Paste.
Right-click the foreign key table and click Relationships on the shortcut menu.
The Foreign Key Relationships dialog box opens.
Create a relationship between the primary key and foreign key columns.