That's why I think that expose a basic SQL ANSI catalog would make this kind of work and others a lot easier.
? > Fri Aug 21 2015 22:13:00 CEST from "Simon Slavin" <slavins at bigfraud.org> >Subject: Re: [sqlite] Is this a bug ? How to rename a table and all >dependencies ? > > 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. > _______________________________________________ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > > > ?