Database Trigger - Triggers in SQLite

Triggers in SQLite

CREATE TRIGGER trigger_name {DELETE | INSERT | UPDATE ...]} ON {TABLE_NAME | view_name} BEGIN ... END

SQLite only supports row-level triggers, not statement-level triggers.

Updateable views, which are not supported in SQLite, can be emulated with INSTEAD OF triggers.