Lines Matching refs:INDEX
15 # focus of this file is testing the CREATE INDEX statement.
26 execsql {CREATE INDEX index1 ON test1(f1)}
32 } {index1 {CREATE INDEX index1 ON test1(f1)} test1 index}
38 } {index1 {CREATE INDEX index1 ON test1(f1)} test1 index}
55 set v [catch {execsql {CREATE INDEX index1 ON test1(f1)}} msg]
64 set v [catch {execsql {CREATE INDEX index1 ON test1(f4)}} msg]
71 set v [catch {execsql {CREATE INDEX index1 ON test1(f1, f2, f4, f3)}} msg]
85 set sql "CREATE INDEX [format index%02d $i] ON test1(f[expr {($i%5)+1}])"
115 execsql {CREATE INDEX index9 ON test1(cnt)}
116 execsql {CREATE INDEX indext ON test1(power)}
129 execsql {DROP INDEX indext}
136 execsql {CREATE INDEX indext ON test1(cnt)}
143 execsql {DROP INDEX index9}
150 execsql {DROP INDEX indext}
165 set v [catch {execsql {CREATE INDEX index1 ON sqlite_master(name)}} msg]
177 execsql {CREATE INDEX index1 ON test1(f1)}
178 set v [catch {execsql {CREATE INDEX index1 ON test2(g1)}} msg]
185 set v [catch {execsql {CREATE INDEX test1 ON test2(g1)}} msg]
199 CREATE INDEX index1 ON test1(a);
200 CREATE INDEX index2 ON test1(b);
201 CREATE INDEX index3 ON test1(a,b);
236 set v [catch {execsql {DROP INDEX index1}} msg]
245 execsql {EXPLAIN CREATE INDEX idx1 ON tab1(a)}
249 execsql {CREATE INDEX idx1 ON tab1(a)}
259 CREATE INDEX i1 ON t1(a);
380 CREATE INDEX t4i1 ON t4(a);
419 DROP INDEX '[lindex $::idxlist $i]';
436 CREATE INDEX t6i1 ON t6(a,b);
525 CREATE INDEX "t6i2" ON t6(c);
526 DROP INDEX "t6i2";
531 DROP INDEX "t6i1";