Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Applies to: 
SQL Server
You can create relationships between columns in different tables in the Diagram Designer by dragging columns between tables.
Create a relationship graphically
In Database Designer, select the row selector for one or more database columns that you want to relate to a column in another table.
Drag the selected columns to the related table.
Two dialog boxes appear: Foreign Key Relationship and Tables and Columns, with the latter appearing in the foreground.
Relationship name has a system-provided name in the format FK_localtable_foreigntable. You might change this value.
Verify that Primary key table specifies the correct table.
The grid lists the local columns and their matching foreign columns. You can add or remove table columns or change mappings.
Choose OK.
The Foreign Key Relationship dialog box appears. Selected Relationship shows the relationship you have created.
Change properties for the relationship in the grid.
Choose OK to create the relationship.
Database Designer shows a relationship between the columns you chose.