Lines Matching refs:TABLE
13 # focus of this file is testing the CREATE TABLE statement.
24 CREATE TABLE test1 (
32 } {{CREATE TABLE test1 (
56 execsql {DROP TABLE test1}
72 execsql {CREATE TABLE "create" (f1 int)}
76 execsql {DROP TABLE "create"}
80 execsql {CREATE TABLE test1("f1 ho" int)}
84 execsql {DROP TABLE "TEST1"}
93 execsql {CREATE TABLE TEST2(one text)}
94 set v [catch {execsql {CREATE TABLE test2(two text)}} msg]
98 set v [catch {execsql {CREATE TABLE sqlite_master(two text)}} msg]
104 set v [catch {execsql {CREATE TABLE sqlite_master(two text)}} msg]
108 execsql {DROP TABLE test2; SELECT name FROM sqlite_master WHERE type!='meta'}
114 execsql {CREATE TABLE test2(one text); CREATE INDEX test3 ON test2(one)}
115 set v [catch {execsql {CREATE TABLE test3(two text)}} msg]
121 set v [catch {execsql {CREATE TABLE test3(two text)}} msg]
129 set v [catch {execsql {CREATE TABLE test3(two text)}} msg]
136 execsql {DROP TABLE test2; DROP TABLE test3}
143 {CREATE TABLE big(
170 set v [catch {execsql {CREATE TABLE BIG(xyz foo)}} msg]
174 set v [catch {execsql {CREATE TABLE biG(xyz foo)}} msg]
178 set v [catch {execsql {CREATE TABLE bIg(xyz foo)}} msg]
184 set v [catch {execsql {CREATE TABLE Big(xyz foo)}} msg]
188 execsql {DROP TABLE big}
200 set sql "CREATE TABLE [format test%03d $i] ("
224 set sql "DROP TABLE [format TEST%03d $i]"
235 set sql "DROP TABLE [format test%03d $i]"
244 set v [catch {execsql {DROP TABLE test009}} msg]
251 set v [catch {execsql {DROP TABLE sqlite_master}} msg]
258 execsql {EXPLAIN CREATE TABLE test1(f1 int)}
265 execsql {CREATE TABLE test1(f1 int)}
266 execsql {EXPLAIN DROP TABLE test1}
273 # execsql {CREATE TABLE 'Spaces In This Name!'(x int)}
282 CREATE TABLE weird(
306 # Try out the CREATE TABLE AS syntax
310 CREATE TABLE t2 AS SELECT * FROM weird;
318 } {{CREATE TABLE t2(
329 CREATE TABLE 't3''xyz'(a,b,c);
336 CREATE TABLE [t4'abc] AS SELECT count(*) as cnt, max(b+c) FROM [t3'xyz];
344 } {{CREATE TABLE 't4''abc'(cnt,'max(b+c)')}}
347 CREATE TEMPORARY TABLE t5 AS SELECT count(*) AS [y'all] FROM [t3'xyz];
370 CREATE TABLE t5 AS SELECT * FROM no_such_table;
378 CREATE TABLE t6(a,b,a);
386 CREATE TABLE t6(a REFERENCES t4(a) NOT NULL);
392 DROP TABLE t6;
393 CREATE TABLE t6(a REFERENCES t4(a) MATCH PARTIAL);
398 DROP TABLE t6;
399 CREATE TABLE t6(a REFERENCES t4 MATCH FULL ON DELETE SET NULL NOT NULL);
404 DROP TABLE t6;
405 CREATE TABLE t6(a REFERENCES t4 MATCH FULL ON UPDATE SET DEFAULT DEFAULT 1);
410 DROP TABLE t6;
411 CREATE TABLE t6(a NOT NULL NOT DEFERRABLE INITIALLY IMMEDIATE);
416 DROP TABLE t6;
417 CREATE TABLE t6(a NOT NULL DEFERRABLE INITIALLY DEFERRED);
422 DROP TABLE t6;
423 CREATE TABLE t6(a,
430 DROP TABLE t6;
431 CREATE TABLE t6(a,b,c,
439 DROP TABLE t6;
440 CREATE TABLE t6(a,b,c,
446 catchsql {DROP TABLE t6}
448 CREATE TABLE t6(a,b,c,
454 catchsql {DROP TABLE t6}
456 CREATE TABLE t6(a,b, c REFERENCES t4(x,y));
460 catchsql {DROP TABLE t6}
462 CREATE TABLE t6(a,b,c,
468 catchsql {DROP TABLE t6}
470 CREATE TABLE t6(a,b,c,
481 CREATE TABLE t7(