Creating a foreign key relationship from a parent table or view to a child table

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:
  1. 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
  2. Select the parent table that has the primary key, or select a view to create a view relationship.
  3. 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.

Feedback