Lines Matching refs:view

50     set sql "SELECT '$name.' || name FROM $tbl WHERE type = 'view'"
73 # -- syntax diagram drop-view-stmt
92 # EVIDENCE-OF: R-27002-52307 The DROP VIEW statement removes a view
97   CREATE VIEW "new view" AS SELECT * FROM t1 AS x, t1 AS y;
98   SELECT * FROM "new view";
101   SELECT * FROM sqlite_master WHERE name = 'new view';
103   view {new view} {new view} 0 
104   {CREATE VIEW "new view" AS SELECT * FROM t1 AS x, t1 AS y}
107   DROP VIEW "new view";
108   SELECT * FROM sqlite_master WHERE name = 'new view';
111   SELECT * FROM "new view"
112 } {1 {no such table: new view}}
114 # EVIDENCE-OF: R-00359-41639 The view definition is removed from the
118 #     For each view in the database, check that it can be queried. Then drop
161 # EVIDENCE-OF: R-25558-37487 If the specified view cannot be found and
167   no such view: %s
174 # EVIDENCE-OF: R-07490-32536 If the specified view cannot be found and