On 22 Mar 2017, at 11:52am, R Smith <rsm...@rsweb.co.za> wrote: > > May I add further that views are tricky things. They can refer to multiple > tables, or other views which in turn refer to multiple tables or yet other > views (and have obscured the names of the original tables via "AS" aliasing). > 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).
I think I’ve tried to do the equivalent thing for TRIGGERs and also failed. And there’s also FOREIGN KEYs, though you can figure those out using PRAGMA calls. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users