You can create a foreign key relationship from a parent table or
view to a child parent table in a physical data model diagram.
To create a foreign key relationship:
- Select a type of relationship in the palette. You can
select the following types of relationships:
- Identifying
- Non-Identifying Optional
- Non-Identifying Mandatory
- Non-Identifying One-to-One
- View Relationship
- Select the parent table that has the primary key, or select a view
to create a view relationship.
- Drag to the child table. Depending on the type
of relationship you are creating, a pop up window might open asking you to
specify relationship options.
The key is migrated from the parent table or view to the child table.