From the page https://sqlite.org/lang_createview.html :
"The CREATE VIEW command assigns a name to a pre-packaged SELECT
statement ..."
So, it seems that the command "CREATE VIEW" just creates a name for a
SELECT statement, and checks nothing more than syntax.
On 28.3.2019 21:21, Mark Wagner wrote:
CREATE VIEW v as select * from t join s on (foo = q);
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users