Displaying foreign key properties
To display the foreign key properties:
Procedure
- Select a table in the left pane.
-
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.
-