Lines Matching refs:KEY

25     CREATE TABLE p1(a PRIMARY KEY, b);
32     CREATE TABLE p1(a PRIMARY KEY, b);
40     CREATE TABLE 'p 1'(a, b, c, PRIMARY KEY(c, b));
41     CREATE TABLE 'c 1'(x, y, z, FOREIGN KEY (z, y) REFERENCES 'p 1');
47     CREATE TABLE p1(a, 'b b b' PRIMARY KEY);
54     CREATE TABLE p1(a, 'b b b' PRIMARY KEY);
63     CREATE TABLE y1(a, b, c, FOREIGN KEY(b, a) REFERENCES x1(a, b));
77     CREATE TABLE x1(a PRIMARY KEY COLLATE nocase, b);
84     CREATE TABLE x1(a, b COLLATE nocase, c COLLATE rtrim, PRIMARY KEY(c, b, a));
85     CREATE TABLE y1(d, e, f, FOREIGN KEY(d, e, f) REFERENCES x1);
92     CREATE TABLE c1(x INTEGER PRIMARY KEY REFERENCES p1(b));
97     CREATE TABLE parent (id INTEGER PRIMARY KEY); 
98     CREATE TABLE child2 (id INT PRIMARY KEY, parentID INT REFERENCES parent)