SQLite Forum

How to detect invalid trigger w/o actually running it?
Login
Thanks for the suggestion. Although with triggers, it can't be just SELECTs,  
and coming up with all kinds of *dummy* statements to explain, so one can be  
sure there's no mistake hiding in the schema seems less than ideal.

Surely there has got to be a better way?

And if not at the moment, shouldn't there be a `pragma check_schema` in the future,  
that checks everything declared in `sqlite_schema` is OK, referencing existing tables/views/columns, that is *opt-in*.