Displaying foreign key properties

To display the foreign key properties:

Procedure

  1. Select a table in the left pane.
  2. In the right pane, click Foreign Key.

    The following details appear:

    • Name: The name of the foreign key constraint.

    • Metadata UID: The internal UID number of the foreign key.

    • Referenced Table: The name of the referenced table.

    • Referencing Column: The name of the referencing column of the foreign key.

    • Referenced Column: The name of the referenced column of the foreign key.

    • Enforced: The property indicates whether the referential integrity is enforced.

    • On Delete: The rule specifies the referential action that is taken when a row in referenced table is deleted.

    • On Update: The rule specifies the referential action that is taken when column list in referenced table is updated.