On 21 Aug 2015, at 9:07pm, Scott Hess <shess at google.com> wrote: > That said, writing code to do this manually has potential to be error > prone. It might make sense under an ENABLE flag. It feels like an obvious > thing to have, not something out-of-scope like embedding a new language or > support for a new storage methodology.
To do it correctly you'd have to identify all table names used by each trigger and view. Which means you have to parse the VIEWs and TRIGGERs and look in all the positions where you'd expect to find a table name. I don't know whether the existing SQLite statement parser could be used for this but it does seem to be a complicated task. Simon.
