Online Documentation for SQL Manager for Oracle

Foreign Keys


An integrity constraint is a rule that restricts the values in a database.

 

A foreign key constraint requires values in one table to match values in another table. A Foreign key constraint (also called a referential integrity constraint) designates a column as the Foreign key and establishes a relationship between that foreign key and a specified Primary or Unique key called the referenced key.

 

Table/view foreign keys are managed within the Foreign Keys tab of Table Editor/View Editor.

 

Creating Foreign Keys

  • open the table/view in Table Editor/View Editor;
  • proceed to the Foreign Keys tab there;
  • right-click the tab area and select the New Foreign Key context menu item, or press the Ins key;
  • define the Foreign key properties using Foreign Key Editor.

 

Editing Foreign Keys

  • open the table/view in Table Editor/View Editor;
  • proceed to the Foreign Keys tab there;
  • right-click the Foreign key to edit and select the Edit Foreign Key <foreign_key_name> context menu item, or simply double-click the Foreign key;
  • edit the Foreign key properties using Foreign Key Editor.

 

Dropping Foreign Keys

  • open the table/view in Table Editor/View Editor;
  • proceed to the Foreign Keys tab there;
  • right-click the Foreign key and select the Drop Foreign Key <foreign_key_name> context menu item;
  • confirm dropping in the dialog window.