Managing foreign keys
Table foreign keys are managed on the Foreign Keys tab of the Table Editor.
To add a foreign key to the table:
- Open the table in the Table Editor.
- Open the Constaraints tab then choose the Foreign Keys tab.
- Right-click and select the Add Foreign Key... item from the popup menu.
- Edit foreign key properties within the Foreign Key Editor dialog.
To edit foreign key:
- Open the table in the Table Editor.
- Open the Constaraints tab then choose the Foreign Keys tab.
- Right-click the foreign key and select the Edit Foreign Key item from the popup menu or simply double-click the key to edit.
- Edit foreign key properties within the Foreign Key Editor Dialog.
To drop the foreign key:
- Open the table in the Table Editor.
- Open the Constaraints tab then choose the Foreign Keys tab.
- Right-click the key to drop and select the Drop Foreign Key item from the popup menu.
- Confirm dropping in the dialog window.
