Lines Matching refs:INDEX

6594 ** one exception. When executing a "DROP TABLE" or "DROP INDEX" statement,
6600 ** or "DROP INDEX" query, an infinite loop might be the result.
6605 ** the special "DROP TABLE/INDEX" case, the extended error code is just 
9575 **     CREATE INDEX Ex2 ON Ex1(c3,c1);
9902 **      CREATE INDEX idx ON t(a,b,c);
41055 ** has been removed (CREATE INDEX needs to move a page when a statement
41704 ** WAL-INDEX FORMAT
72582 ** CREATE INDEX command. The second is a table name. The table name in 
72583 ** the CREATE TABLE or CREATE INDEX statement is replaced with the third
72589 ** sqlite_rename_table('CREATE INDEX i ON abc(a)', 'def')
72590 **     -> 'CREATE INDEX i ON def(a, b, c)'
72710 ** TRIGGER, not CREATE INDEX and CREATE TABLE.
74869 **     CREATE INDEX
74870 **     DROP INDEX
77208   Token *pEnd,       /* The ")" that closes the CREATE INDEX statement */
77565   ** The db->init.busy is 0 when the user first enters a CREATE INDEX 
77567   ** CREATE INDEX statements are read out of the master table.  In
77590     /* Gather the complete text of the CREATE INDEX statement into
77595       /* A named index with an explicit CREATE INDEX statement */
77596       zStmt = sqlite3MPrintf(db, "CREATE%s INDEX %.*s",
77703 ** implements the DROP INDEX statement.
87049     /* Call the parser to process a CREATE TABLE, INDEX or VIEW.
94448       "SELECT 'CREATE INDEX vacuum_db.' || substr(sql,14)"
94449       "  FROM sqlite_master WHERE sql LIKE 'CREATE INDEX %' ");
94452       "SELECT 'CREATE UNIQUE INDEX vacuum_db.' || substr(sql,21) "
94453       "  FROM sqlite_master WHERE sql LIKE 'CREATE UNIQUE INDEX %'");
98620     ** Ex: CREATE INDEX i1 ON t1(a,b,a); SELECT * FROM t1 WHERE a=0 AND b=0; */
98787       zMsg = sqlite3MAppendf(db, zMsg, "%s VIRTUAL TABLE INDEX %d:%s", zMsg,
99243     **   CREATE INDEX i1 ON t1(a);
99244     **   CREATE INDEX i2 ON t1(b);
99245     **   CREATE INDEX i3 ON t1(c);
101144   "THEN",          "ELSE",          "INDEX",         "ALTER",       
101423  /* 243 */ "cmd ::= createkw uniqueflag INDEX ifnotexists nm dbnm ON nm LP idxlist RP",
101432  /* 252 */ "cmd ::= DROP INDEX ifexists fullname",
103092       case 243: /* cmd ::= createkw uniqueflag INDEX ifnotexists nm dbnm ON nm LP idxlist RP */
103135       case 252: /* cmd ::= DROP INDEX ifexists fullname */
103840       testcase( i==2 ); /* INDEX */