Lines Matching refs:VIEW

105   CREATE VIEW vvv AS SELECT main.txx.a, txx.b, c FROM txx;
106   CREATE VIEW uuu AS SELECT main.one.a, one.b, c FROM txx AS one;
107   CREATE VIEW temp.ttt AS SELECT main.txx.a, txx.b, one.b, main.one.a FROM txx AS one, txx;
121 } {{CREATE VIEW vvv AS SELECT main.txx.a, txx.b, c FROM txx}}
129 } {{CREATE VIEW uuu AS SELECT main.one.a, one.b, c FROM txx AS one}}
136 } {{CREATE VIEW ttt AS SELECT main.txx.a, txx.b, one.b, main.one.a FROM txx AS one, txx}}
204   CREATE VIEW v AS SELECT one.a, one.b, t2.a, t2.b FROM t1 AS one, t2;
218   DROP VIEW v;
219   CREATE VIEW temp.vv AS SELECT one.a, one.b, t2.a, t2.b FROM t1 AS one, t2;
293   CREATE VIEW v1 AS SELECT * FROM t2;
302   DROP VIEW v1;
459   CREATE VIEW v1 AS SELECT * FROM t1;