Lines Matching full:create
21 CREATE TABLE t1(a,b,c);
32 CREATE VIEW v1 AS SELECT a,b FROM t1;
44 CREATE VIEW v1 AS SELECT a,b FROM t1;
63 CREATE VIEW v1 AS SELECT a,b FROM t1;
75 CREATE TABLE t1(x,a,b,c);
92 CREATE VIEW v2 AS SELECT * FROM t1 WHERE a>5
140 CREATE VIEW v1 AS SELECT a AS 'xyz', b+c AS 'pqr', c-b FROM t1;
146 CREATE VIEW v3 AS SELECT a FROM t1 UNION SELECT b FROM t1 ORDER BY b;
152 CREATE VIEW v4 AS
184 CREATE INDEX i1v1 ON v1(xyz);
190 CREATE TABLE t2(y,a);
200 CREATE VIEW v5 AS
257 CREATE TABLE test1(id integer primary key, a);
258 CREATE TABLE test2(id integer, b);
261 CREATE VIEW test AS
277 CREATE VIEW test AS
293 CREATE VIEW test AS
309 CREATE VIEW v6 AS SELECT pqr, xyz FROM v1;
322 CREATE VIEW v7 AS SELECT pqr+xyz AS a FROM v6;
328 CREATE VIEW v8 AS SELECT max(cnt) AS mx FROM
366 CREATE VIEW v9 AS
378 CREATE VIEW v10 AS
394 CREATE TABLE t3("9" integer, [4] text);
396 CREATE VIEW v_t3_a AS SELECT a.[9] FROM t3 AS a;
397 CREATE VIEW v_t3_b AS SELECT "4" FROM t3;