1. May be added note "All triggers associated with the view are also deleted." to http://www.sqlite.org/lang_dropview.html
2. This behaviour is incompatible with other DBMS and undocumented: sqlite> create table a(a); sqlite> create view b as select * from a; sqlite> drop table a; sqlite> select * from b; Error: no such table: main.a sqlite> .s CREATE VIEW b as select * from a; sqlite> create view a as select 1; sqlite> create view b as select * from a; sqlite> drop view a; sqlite> select * from b; Error: no such table: main.a sqlite> .s CREATE VIEW b as select * from a; This strange, really. View cannot reference objects in attached databases but view can reference deleted object? -- Best regards, Alexey Pechnikov. http://pechnikov.tel/ _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users