1. Using Oracle Database Actions for On-Premises Oracle Database
  2. The SQL and Data Modeler Pages
  3. Creating and Editing Database Objects
  4. The Table Properties Dialog
  5. Foreign Keys Pane

3.4.1.5 Foreign Keys Pane

Specifies one or more foreign keys for the table.

A foreign key specifies a column ("local column"), whose data values match values in the primary key or unique constraint of another table.

  • Name: Name of the foreign key definition.

  • Enabled: If this option is checked, the foreign key is enforced.

  • Rely, Deferrable, Initially Immediate, Validate: See the description of these fields in the Unique Keys pane.

  • Referenced Constraint: Schema: Name of the schema containing the table with the primary key or unique constraint to which this foreign key refers.

  • Referenced Constraint: Table: Name of the table with the primary key or unique constraint to which this foreign key refers.

  • Referenced Constraint: Constraint: Name of the primary key or unique constraint to which this foreign key refers.

  • Referenced Constraint: On Delete: Action to take automatically when a row in the referenced table is deleted and rows with that value exist in the table containing this foreign key: NO ACTION (shown by a crossing line in diagrams) performs no action on these rows; CASCADE (shown by an "X") deletes these rows; SET NULL (shown by a small circle) sets null all columns in those rows that can be set to a null value.

  • Assocations: Local Column: Lists the column in the currently selected (local) table that is included in the foreign key definition. For each referenced column in the foreign key definition, select the name of a column in the edited table.

  • Associations: Referenced Column: For each local column, identifies the column in the other (foreign) table that must have a value matching the value in the local column.