Lines Matching refs:KEY

32   CREATE TABLE t1(a PRIMARY KEY,b,c);
33   CREATE TABLE t1w(a PRIMARY KEY,b,c) WITHOUT ROWID;
51 # KEY, cnt INTEGER ) WITHOUT ROWID;
55     word TEXT PRIMARY KEY,
70     word TEXT PRIMARY KEY,
80     word TEXT PRIMARY KEY,
90     word TEXT PRIMARY KEY,
104     word TEXT PRIMARY KEY,
110     word TEXT PRIMARY KEY,
116 # statement with the WITHOUT ROWID clause lacks a PRIMARY KEY.
119 # PRIMARY KEY.
122 # without a PRIMARY KEY results in an error.
129 } {1 {PRIMARY KEY missing on table error3}}
132 # PRIMARY KEY" do not apply on WITHOUT ROWID tables.
135   CREATE TABLE ipk(key INTEGER PRIMARY KEY, val TEXT) WITHOUT ROWID;
155   CREATE TABLE ipk2(key INTEGER PRIMARY KEY AUTOINCREMENT, val TEXT)WITHOUT ROWID;
159 # PRIMARY KEY in a WITHOUT ROWID table.
162 # the SQL standard and allow NULL values in PRIMARY KEY fields.
166 # a PRIMARY KEY column.
169   CREATE TABLE nn(a, b, c, d, e, PRIMARY KEY(c,a,e));
170   CREATE TABLE nnw(a, b, c, d, e, PRIMARY KEY(c,a,e)) WITHOUT ROWID;
203       PRIMARY KEY(a,b)
220       PRIMARY KEY(a,b)
238       PRIMARY KEY(a,b)
253       PRIMARY KEY(a,b)
266       PRIMARY KEY(a,b)
280   CREATE TABLE b1(a INTEGER PRIMARY KEY, b BLOB) WITHOUT ROWID;