How to create a FOREIGN KEY constraint using a database diagram (Enterprise Manager)

To create a FOREIGN KEY constraint using a database diagram

1. Open a database diagram.
2. If you have not already defined a PRIMARY KEY or UNIQUE constraint in the foreign key table, do so now.
3. In the foreign key table, create a column.

   The foreign key column must match the data type and size of the primary key column, with these exceptions:

   • A char column or sysname column can relate to a varchar column.
   • A binary column can relate to a varbinary column.
   • A user-defined data type can relate to its base type.
4. Click the primary key columns that you want to copy to the foreign key table.
5. Copy the columns from the primary key table to the foreign key table.

See Also