Dominique Devienne wrote: > On Wed, Mar 22, 2017 at 12:52 PM, R Smith <rsm...@rsweb.co.za> wrote: >> There is no way to easily implement an automatic view-of-table >> dropper. (I've tried to do something like this for an sqlite tool long ago). > > Yes but... You can run a simple query on the view, like "select rowid from v" > and EXPLAIN that, > and look for specific OpCodes [1] (like OpenRead), look at its P2 arg, and > lookup that root page in > sqlite_master.
sqlite3_set_authorizer() would be easier, and an official API. Regards, Clemens _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
