The Foreign Keys
tab is divided into two
sections, one with a list of foreign keys and one with various
dialogs for foreign key settings.
To add a foreign key, click the + (plus) button below the foreign key list. You will be prompted to name the new foreign key, and it is then be added to the list.
To drop a foreign key, select the foreign key and click the - (minus) button below the foreign key list. The foreign key is then dropped from the foreign key list.
You can modify the name of the foreign key, its ON
DELETE
, and its ON UPDATE
actions
using the dialogs provided in the Foreign Key
Settings section of the tab.
To establish a foreign key relationship, choose a table from the Ref. Table drop-down list. The columns that can be referenced as foreign keys are listed in the area below, and you can drag a column from the column editor to the Column section to the left of the column you wish to reference.