Foreign Key Editor

Data Tool's Foreign Key Editor allows adding and deleting foreign key constraints on the currently selected table.

How to create a foreign key constraint

  1. Select a table in the SQL Console's object list.
  2. Click the Foreign button below the object list.

    The database often returns this information very slowly; it might take a few moments for the dialog to open.

  3. Click the Add button and select a table from a dropdown and a column in a listbox for two tables that have a foreign key relationship.

    4. Foreign Key Add Dialog

  4. Then click Add. The dialog will close and the DDL statement will appear in the editor's SQL textarea.

    5. Foreign Key Dialog

  5. Click 'Go' to replace the generated DDL into the SQL Console, close the editor, and run the statements.

Back to Table of Contents.