Lines Matching refs:t4
338 CREATE TABLE [t4'abc] AS SELECT count(*) as cnt, max(b+c) FROM [t3'xyz];
339 SELECT * FROM [t4'abc];
344 SELECT sql FROM sqlite_master WHERE name='t4''abc'
346 } {{CREATE TABLE 't4''abc'(cnt,'max(b+c)')}}
357 SELECT * FROM [t4'abc];
388 CREATE TABLE t6(a REFERENCES t4(a) NOT NULL);
395 CREATE TABLE t6(a REFERENCES t4(a) MATCH PARTIAL);
401 CREATE TABLE t6(a REFERENCES t4 MATCH FULL ON DELETE SET NULL NOT NULL);
407 CREATE TABLE t6(a REFERENCES t4 MATCH FULL ON UPDATE SET DEFAULT DEFAULT 1);
426 FOREIGN KEY (a) REFERENCES t4(b) DEFERRABLE INITIALLY DEFERRED
434 FOREIGN KEY (b,c) REFERENCES t4(x,y) MATCH PARTIAL
443 FOREIGN KEY (b,c) REFERENCES t4(x)
451 FOREIGN KEY (b,c) REFERENCES t4(x,y,z)
458 CREATE TABLE t6(a,b, c REFERENCES t4(x,y));
460 } {1 {foreign key on c should reference only one column of table t4}}
465 FOREIGN KEY (b,x) REFERENCES t4(x,y)
473 FOREIGN KEY (x,b) REFERENCES t4(x,y)