Lines Matching refs:VIEW
29 CREATE VIEW v1 AS SELECT * FROM t1;
30 CREATE VIEW v2 AS SELECT * FROM t1;
34 CREATE VIEW temp.v1 AS SELECT * FROM t1;
38 CREATE VIEW aux.v1 AS SELECT * FROM t1;
39 CREATE VIEW aux.v2 AS SELECT * FROM t1;
40 CREATE VIEW aux.v3 AS SELECT * FROM t1;
75 # All paths in the syntax diagram for DROP VIEW are tested by tests 1.*.
82 1 "DROP VIEW v1" {main.v1 main.v2 aux.v1 aux.v2 aux.v3}
83 2 "DROP VIEW v2" {main.v1 temp.v1 aux.v1 aux.v2 aux.v3}
84 3 "DROP VIEW main.v1" {main.v2 temp.v1 aux.v1 aux.v2 aux.v3}
85 4 "DROP VIEW main.v2" {main.v1 temp.v1 aux.v1 aux.v2 aux.v3}
86 5 "DROP VIEW IF EXISTS v1" {main.v1 main.v2 aux.v1 aux.v2 aux.v3}
87 6 "DROP VIEW IF EXISTS v2" {main.v1 temp.v1 aux.v1 aux.v2 aux.v3}
88 7 "DROP VIEW IF EXISTS main.v1" {main.v2 temp.v1 aux.v1 aux.v2 aux.v3}
89 8 "DROP VIEW IF EXISTS main.v2" {main.v1 temp.v1 aux.v1 aux.v2 aux.v3}
92 # EVIDENCE-OF: R-27002-52307 The DROP VIEW statement removes a view
93 # created by the CREATE VIEW statement.
97 CREATE VIEW "new view" AS SELECT * FROM t1 AS x, t1 AS y;
104 {CREATE VIEW "new view" AS SELECT * FROM t1 AS x, t1 AS y}
107 DROP VIEW "new view";
126 do_execsql_test 3.1.1 { DROP VIEW temp.v1 } {}
132 do_execsql_test 3.2.1 { DROP VIEW v1 } {}
138 do_execsql_test 3.3.1 { DROP VIEW v2 } {}
144 do_execsql_test 3.4.1 { DROP VIEW v1 } {}
150 do_execsql_test 3.5.1 { DROP VIEW aux.v2 } {}
156 do_execsql_test 3.6.1 { DROP VIEW v3 } {}
169 1 "DROP VIEW xx" xx
170 2 "DROP VIEW main.xx" main.xx
171 3 "DROP VIEW temp.v2" temp.v2
175 # an IF EXISTS clause is present in the DROP VIEW statement, then the
184 1 "DROP VIEW IF EXISTS xx" "main.v1 main.v2 temp.v1 aux.v1 aux.v2 aux.v3"
185 2 "DROP VIEW IF EXISTS main.xx" "main.v1 main.v2 temp.v1 aux.v1 aux.v2 aux.v3"
186 3 "DROP VIEW IF EXISTS temp.v2" "main.v1 main.v2 temp.v1 aux.v1 aux.v2 aux.v3"