Schema
Relationships
View and manage foreign key relationships.
Viewing Relationships
Foreign keys are displayed in the schema browser with a link icon. Click a foreign key column to see the referenced table and column.
Creating Foreign Keys
Use the Table Designer to add foreign key constraints:
- Open the table in the Table Designer
- Navigate to the Foreign Keys tab
- Select the source column, referenced table, and referenced column
- Choose the ON DELETE and ON UPDATE actions
Actions
| Action | Description |
|---|---|
CASCADE | Propagate changes to related rows |
SET NULL | Set foreign key to NULL |
SET DEFAULT | Set foreign key to its default value |
RESTRICT | Prevent the operation |
NO ACTION | Defer check to end of transaction |