On 24 Mar 2017, at 12:45am, Domingo Alvarez Duarte <mingo...@gmail.com> wrote:
> It's not that complicated, sqlite already do all work right now but it > doesn't store that information in a structured way "data dictionary". SQLite does not seem to parse views or triggers for dependencies. If it did it wouldn’t allow this view or these triggers. SQLite version 3.16.0 2016-11-04 19:09:39 Enter ".help" for usage hints. sqlite> CREATE TABLE ta (c1 TEXT); sqlite> CREATE TABLE tb (c2 TEXT, c3 TEXT); sqlite> CREATE VIEW v1 AS SELECT i1 FROM ia; sqlite> PRAGMA table_info(v1); Error: no such table: main.ia sqlite> CREATE TRIGGER t22 BEFORE INSERT ON tb ...> FOR EACH ROW BEGIN ...> INSERT INTO ta (fred) VALUES (new.c2); ...> END; sqlite> CREATE TRIGGER t23 BEFORE INSERT ON tb ...> FOR EACH ROW BEGIN ...> INSERT INTO gradsad VALUES (ajsdhasd); ...> END; sqlite> Simon. _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
