Lines Matching refs:t6
380 CREATE TABLE t6(a,b,a);
388 CREATE TABLE t6(a REFERENCES t4(a) NOT NULL);
389 INSERT INTO t6 VALUES(NULL);
391 } {1 {t6.a may not be 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,