Foreign Keys

A foreign key is a primary or alternate key that migrates from another table. Depending on selected model options, a primary key can be automatically migrated to a child table as a foreign key at reference creation.

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 (seeReferences (PDM)). For information about auto-migration of foreign keys, see Automatic Reuse and Migration of Columns.