SQLite: trigger for multiple tables and/or multiple actions
No, SQLite doesn't appear to have database or server level triggers (like other database systems). Instead you'd have to create the same trigger on each table.

Unfortunately this is also a limitation in SQLite and not possible either.

You might be better off letting the app that connects to the SQLite database (or a secondary process / job depending on if your database is stored on a mobile device vs a computer) control what records get deleted and when. For example, if you were hosting your SQLite database on a Windows machine, you could schedule a Task that routinely cleans up the database. Otherwise you can build it into the framework of your application that whenever a database call is made, the clean up script executes first.


Here is the syntax tree for the CREATE TRIGGER statement on SQLite. It may help clarify what you can and can't do.