On the other hand, creation of a view could ignore the dependencies, and only check them at run time.
It's curious that the following sequence seems to behave this way: create view a as select 1; create view b as select * from a; select * from b; .d drop view a; .d select * from b; --Error: no such table: main.a create view a as select 3; select * from b; ----------- Apparently, a view can exist without its dependencies, so the order of definition should not have to matter. If it indeed does matter, then shouldn’t dropping view a (in the above example) also drop view b, automatically? _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users