Lines Matching refs:KEY

27   CREATE TABLE t1(a,b,c,d, PRIMARY KEY(c,a)) WITHOUT ROWID;
61 # Trying to insert a duplicate PRIMARY KEY fails.
121   CREATE TABLE t4 (a COLLATE nocase PRIMARY KEY, b) WITHOUT ROWID;
135   CREATE TABLE t4 (b, a COLLATE nocase PRIMARY KEY) WITHOUT ROWID;
151   CREATE TABLE t5 (a, b, PRIMARY KEY(b, a)) WITHOUT ROWID;
163     a COLLATE nocase, b, c UNIQUE, PRIMARY KEY(b, a)
187   CREATE TABLE t1(a, b, PRIMARY KEY(a)) WITHOUT ROWID;
190   CREATE TABLE t2(a, b, PRIMARY KEY(a)) WITHOUT ROWID;
215   CREATE TABLE t3(a PRIMARY KEY);
216   CREATE TABLE t4(a PRIMARY KEY);
231   CREATE TABLE t41(a PRIMARY KEY) WITHOUT ROWID;
247   CREATE TABLE t45(a PRIMARY KEY, b, c) WITHOUT ROWID;
276   CREATE TABLE t46(a, b, c, d, PRIMARY KEY(a, b)) WITHOUT ROWID;
308   CREATE TABLE t47(a, b UNIQUE PRIMARY KEY) WITHOUT ROWID;
324     PRIMARY KEY(a), 
341      b TEXT PRIMARY KEY
351      b TEXT PRIMARY KEY
356 # added in the sqlite_master table for an "INTEGER PRIMARY KEY UNIQUE"
362   CREATE TABLE t1(x INTEGER PRIMARY KEY UNIQUE, b) WITHOUT ROWID;
373   CREATE TABLE t2(b, c, PRIMARY KEY(b,c)) WITHOUT ROWID;
387   CREATE TABLE t1(a, b, c UNIQUE, PRIMARY KEY(a, b)) WITHOUT ROWID;
420   CREATE TABLE t11(a TEXT PRIMARY KEY, b INT) WITHOUT ROWID;
430   CREATE TABLE t0 (c0 INTEGER PRIMARY KEY DESC, c1 UNIQUE DEFAULT NULL) WITHOUT ROWID;
437 # The xferCompatibleIndex() function confuses a PRIMARY KEY index
446     PRIMARY KEY(c1, c1)
452     PRIMARY KEY(c1, c1)
463     CREATE TABLE t1(a INT PRIMARY KEY) WITHOUT ROWID;
482     CREATE TABLE sqlite_sequence (name PRIMARY KEY) WITHOUT ROWID;