Constraint Triggers

There is one more unsupported SQL feature. Sqlite does not enforce foreign keys and not null constraints. This action will create a workaround triggers for you. Your SQL DML statements will be checked against these triggers before their execution.

There are three kind of constraint triggers - one for each DML (INSERT/UPDATE/DELETE) operations. This tool suggests trigger names but you can change it in the "Name" widgets.

All triggers will be created after the Create click. Then check the results carefully.

Important

Consult Sqlite WIKI for deeper understanding of FOREIGN KEYS, please.