Creating Foreign Keys

A foreign key is a primary or alternate key migrates from another table. Foreign keys are generally migrated automatically when you draw a reference from a child to a parent table.

The columns that are defined in a foreign key can also be user-specified at creation and changed at any time from the Joins tab of the reference property sheet (see References (PDM)). For information about auto-migration of foreign keys, see Automatic Reuse and Migration of Columns.