Yep Sybase preparse it. When you create a view/sproc/triggers/function the objects referenced must exist or your DDL will fail.
this create some complexity when we want to recreate all the objects, order of creation is very important. 2017-03-23 21:15 GMT-04:00 Simon Slavin <slav...@bigfraud.org>: > > 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 > -- Daniel *L'action accède à la perfection quand, bien que vivant, vous êtes déjà mort* *Bunan* _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
