Use the opened window to specify the triggers names and set foreign key Cascade options. A foreign key is a set of attributes in a table that refers to the primary key of another table. 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). The SQLite foreign key is a basic that checks the presence of a huge worth present in one table to another table that has an association with the essential. 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. SQLite Maestro allows you to enforce foreign key constraints using referential integrity triggers. A foreign key in SQL is a table-level construct that constrains one or more columns in that table to only allow values that are present in a different set. 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.Īll the fields which are included into the Foreign Key must be included into indexes as well. 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)Īnd confirm dropping in the dialog window.
0 Comments
Leave a Reply. |