Lines Matching refs:t4
336 CREATE TABLE [t4'abc] AS SELECT count(*) as cnt, max(b+c) FROM [t3'xyz];
337 SELECT * FROM [t4'abc];
342 SELECT sql FROM sqlite_master WHERE name='t4''abc'
344 } {{CREATE TABLE 't4''abc'(cnt,'max(b+c)')}}
355 SELECT * FROM [t4'abc];
386 CREATE TABLE t6(a REFERENCES t4(a) NOT NULL);
393 CREATE TABLE t6(a REFERENCES t4(a) MATCH PARTIAL);
399 CREATE TABLE t6(a REFERENCES t4 MATCH FULL ON DELETE SET NULL NOT NULL);
405 CREATE TABLE t6(a REFERENCES t4 MATCH FULL ON UPDATE SET DEFAULT DEFAULT 1);
424 FOREIGN KEY (a) REFERENCES t4(b) DEFERRABLE INITIALLY DEFERRED
432 FOREIGN KEY (b,c) REFERENCES t4(x,y) MATCH PARTIAL
441 FOREIGN KEY (b,c) REFERENCES t4(x)
449 FOREIGN KEY (b,c) REFERENCES t4(x,y,z)
456 CREATE TABLE t6(a,b, c REFERENCES t4(x,y));
458 } {1 {foreign key on c should reference only one column of table t4}}
463 FOREIGN KEY (b,x) REFERENCES t4(x,y)
471 FOREIGN KEY (x,b) REFERENCES t4(x,y)