On 3/22/17, 邱朗 <[email protected]> wrote: > Hi, > > > Is there any way to drop view “automatically” when its associated table is > dropped? > It seems no way to do. Then if I drop a table, is there any (easy) way to > find views created based on it and I can drop view manually ? >
There is no easy way to figure out what tables a view refers to. Furthermore, some applications might want to drop a table and then recreate that table (perhaps after adding a new constraint or reordering the columns) and would like to keep using the VIEW. Those applications would not want the VIEW to be dropped automatically. -- D. Richard Hipp [email protected] _______________________________________________ sqlite-users mailing list [email protected] http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
