SQL Maestro Group / Products / SQLite / SQLite Maestro / Documentation

SQLite Maestro online Help

A foreign key is a field (or collection of fields) in one table that uniquely identifies a row of another table. In other words, a foreign key is a column or a combination of columns that is used to establish and enforce a link between the data in two tables.

Foreign keys are created within the Foreign Key Properties dialog window. In order to open the dialog you should either

•	open the table in Table Editor and the Foreign Keys tab there;

•	press the Insert key or select the Add New Foreign Key... item from the popup menu (alternatively, you may use the corresponding link of the Navigation Bar)

•	select the table in the explorer tree and use the Create New Foreign Key popup menu item

•	select the table Foreign Keys node or any foreign key within the table in the explorer tree and use the Add New Foreign Key... popup menu item.

Foreign Keys are edited within the Foreign Key Properties dialog window. In order to open the dialog you should either

•	open the table in Table Editor and the Foreign Keys tab there;

•	press the Enter key or select the Edit Foreign Key item from the popup menu (alternatively, you may use the corresponding link of the Navigation Bar)

•	select the foreign key to edit in the explorer tree and use the Edit Foreign Key popup menu item.

You can change the name of the foreign key using the Rename Foreign Key dialog. To open the dialog you should either

•	select the foreign key to rename in the explorer tree;

•	select the Rename Foreign Key item from the popup menu

•	open the table in Table Editor and the Foreign Keys tab there;

•	select the foreign key to rename;

•	select the Rename Foreign Key item from the popup menu (alternatively, you may use the corresponding link of the Navigation Bar).

To drop the foreign key:

•	select the foreign key to drop in the explorer tree;

•	select the Drop Foreign Key item from the popup menu

•	open the table in Table Editor and the Foreign Keys tab there;

•	press the Delete key or select the Drop Foreign Key item from the popup menu (alternatively, you may use the corresponding link of the Navigation Bar)

and confirm dropping in the dialog window.

Select Columns from the Available Fields list to include into the foreign key, select the Foreign Table Name from the drop-down list and its fields from the list to include, and apply the changes by clicking the OK button.

All the fields which are included into the Foreign Key must be included into indexes as well. See Indexes for details.

SQLite Maestro allows you to enforce foreign key constraints using referential integrity triggers. To generate such triggers to a foreign key, use the Generate referential integrity triggers link of the foreign key node' popup menu at the Explorer tree. This command is provided to generate 4 triggers: 2 triggers will accomplish the referential integrity in the parent table (on update and on delete) and 2 triggers - on the child one (on insert and on update). Use the opened window to specify the triggers names and set foreign key Cascade options.

SQLite Maestro online Help

Foreign Keys

Thanksgiving Sale