Lines Matching refs:CREATE
23 CREATE TABLE t1(a,b,c);
34 CREATE VIEW v1 AS SELECT a,b FROM t1;
46 CREATE VIEW v1 AS SELECT a,b FROM t1;
65 CREATE VIEW v1 AS SELECT a,b FROM t1;
77 CREATE TABLE t1(x,a,b,c);
94 CREATE VIEW v2 AS SELECT * FROM t1 WHERE a>5
142 CREATE VIEW v1 AS SELECT a AS 'xyz', b+c AS 'pqr', c-b FROM t1;
148 CREATE VIEW v3 AS SELECT a FROM t1 UNION SELECT b FROM t1 ORDER BY b;
154 CREATE VIEW v4 AS
186 CREATE INDEX i1v1 ON v1(xyz);
192 CREATE TABLE t2(y,a);
202 CREATE VIEW v5 AS
259 CREATE TABLE test1(id integer primary key, a);
260 CREATE TABLE test2(id integer, b);
263 CREATE VIEW test AS
279 CREATE VIEW test AS
295 CREATE VIEW test AS
311 CREATE VIEW v6 AS SELECT pqr, xyz FROM v1;
324 CREATE VIEW v7 AS SELECT pqr+xyz AS a FROM v6;
330 CREATE VIEW v8 AS SELECT max(cnt) AS mx FROM
368 CREATE VIEW v9 AS
380 CREATE VIEW v10 AS
396 CREATE TABLE t3("9" integer, [4] text);
398 CREATE VIEW v_t3_a AS SELECT a.[9] FROM t3 AS a;
399 CREATE VIEW v_t3_b AS SELECT "4" FROM t3;