Lines Matching refs:TABLE
15 # focus of this file is testing the CREATE TABLE statement.
26 CREATE TABLE test1 (
34 } {{CREATE TABLE test1 (
58 execsql {DROP TABLE test1}
74 execsql {CREATE TABLE "create" (f1 int)}
78 execsql {DROP TABLE "create"}
82 execsql {CREATE TABLE test1("f1 ho" int)}
86 execsql {DROP TABLE "TEST1"}
95 execsql {CREATE TABLE TEST2(one text)}
96 set v [catch {execsql {CREATE TABLE test2(two text)}} msg]
100 set v [catch {execsql {CREATE TABLE sqlite_master(two text)}} msg]
106 set v [catch {execsql {CREATE TABLE sqlite_master(two text)}} msg]
110 execsql {DROP TABLE test2; SELECT name FROM sqlite_master WHERE type!='meta'}
116 execsql {CREATE TABLE test2(one text); CREATE INDEX test3 ON test2(one)}
117 set v [catch {execsql {CREATE TABLE test3(two text)}} msg]
123 set v [catch {execsql {CREATE TABLE test3(two text)}} msg]
131 set v [catch {execsql {CREATE TABLE test3(two text)}} msg]
138 execsql {DROP TABLE test2; DROP TABLE test3}
145 {CREATE TABLE big(
172 set v [catch {execsql {CREATE TABLE BIG(xyz foo)}} msg]
176 set v [catch {execsql {CREATE TABLE biG(xyz foo)}} msg]
180 set v [catch {execsql {CREATE TABLE bIg(xyz foo)}} msg]
186 set v [catch {execsql {CREATE TABLE Big(xyz foo)}} msg]
190 execsql {DROP TABLE big}
202 set sql "CREATE TABLE [format test%03d $i] ("
226 set sql "DROP TABLE [format TEST%03d $i]"
237 set sql "DROP TABLE [format test%03d $i]"
246 set v [catch {execsql {DROP TABLE test009}} msg]
253 set v [catch {execsql {DROP TABLE sqlite_master}} msg]
260 execsql {EXPLAIN CREATE TABLE test1(f1 int)}
267 execsql {CREATE TABLE test1(f1 int)}
268 execsql {EXPLAIN DROP TABLE test1}
275 # execsql {CREATE TABLE 'Spaces In This Name!'(x int)}
284 CREATE TABLE weird(
308 # Try out the CREATE TABLE AS syntax
312 CREATE TABLE t2 AS SELECT * FROM weird;
320 } {{CREATE TABLE t2(
331 CREATE TABLE 't3''xyz'(a,b,c);
338 CREATE TABLE [t4'abc] AS SELECT count(*) as cnt, max(b+c) FROM [t3'xyz];
346 } {{CREATE TABLE 't4''abc'(cnt,'max(b+c)')}}
349 CREATE TEMPORARY TABLE t5 AS SELECT count(*) AS [y'all] FROM [t3'xyz];
372 CREATE TABLE t5 AS SELECT * FROM no_such_table;
380 CREATE TABLE t6(a,b,a);
388 CREATE TABLE t6(a REFERENCES t4(a) NOT NULL);
394 DROP TABLE t6;
395 CREATE TABLE t6(a REFERENCES t4(a) MATCH PARTIAL);
400 DROP TABLE t6;
401 CREATE TABLE t6(a REFERENCES t4 MATCH FULL ON DELETE SET NULL NOT NULL);
406 DROP TABLE t6;
407 CREATE TABLE t6(a REFERENCES t4 MATCH FULL ON UPDATE SET DEFAULT DEFAULT 1);
412 DROP TABLE t6;
413 CREATE TABLE t6(a NOT NULL NOT DEFERRABLE INITIALLY IMMEDIATE);
418 DROP TABLE t6;
419 CREATE TABLE t6(a NOT NULL DEFERRABLE INITIALLY DEFERRED);
424 DROP TABLE t6;
425 CREATE TABLE t6(a,
432 DROP TABLE t6;
433 CREATE TABLE t6(a,b,c,
441 DROP TABLE t6;
442 CREATE TABLE t6(a,b,c,
448 catchsql {DROP TABLE t6}
450 CREATE TABLE t6(a,b,c,
456 catchsql {DROP TABLE t6}
458 CREATE TABLE t6(a,b, c REFERENCES t4(x,y));
462 catchsql {DROP TABLE t6}
464 CREATE TABLE t6(a,b,c,
470 catchsql {DROP TABLE t6}
472 CREATE TABLE t6(a,b,c,
483 CREATE TABLE t7(