Lines Matching refs:WHERE
653 "UPDATE", "USING", "VACUUM", "VALUES", "VIEW", "VIRTUAL", "WHEN", "WHERE",
2127 " WHERE type='table'\n"
2893 ** rowids on tables where the rowid is inaccessible because there are other
2905 " WHERE origin='pk'", zTab);
3147 ".mode MODE ?TABLE? Set output mode where MODE is one of:\n"
3877 " WHERE %s", zWhere);
3904 " WHERE %s ORDER BY rowid DESC", zWhere);
4021 "SELECT count(*) FROM %s WHERE type='table'" },
4023 "SELECT count(*) FROM %s WHERE type='index'" },
4025 "SELECT count(*) FROM %s WHERE type='trigger'" },
4027 "SELECT count(*) FROM %s WHERE type='view'" },
4237 ** function returns the string " COLLATE <parent-collation>", where
4301 ** "EXPLAIN QUERY PLAN SELECT rowid FROM child_table WHERE child_key=?"
4332 " 'EXPLAIN QUERY PLAN SELECT rowid FROM ' || quote(s.name) || ' WHERE '"
4342 " (SELECT name FROM pragma_table_info(f.[table]) WHERE pk=seq+1)"
4465 raw_printf(stderr, "Where sub-commands are:\n");
4726 "WHERE sql NOT NULL AND type=='table' AND name!='sqlite_sequence'"
4730 "WHERE name=='sqlite_sequence'"
4734 "WHERE sql NOT NULL AND type IN ('index','trigger','view')", 0
4740 "WHERE tbl_name LIKE %Q AND type=='table'"
4746 "WHERE sql NOT NULL"
4832 "WHERE type!='meta' AND sql NOTNULL AND name NOT LIKE 'sqlite_%' "
4840 " WHERE name GLOB 'sqlite_stat[134]'",
5090 " WHERE name='%q' AND type='index'", azArg[1]);
5566 "WHERE lower(tbl_name) LIKE %Q"
5578 "WHERE type!='meta' AND sql NOTNULL AND name NOT LIKE 'sqlite_%' "
6001 " WHERE type='table' AND coalesce(rootpage,0)>1"
6006 " WHERE type='table' AND coalesce(rootpage,0)>1"
6149 ** main and all attached databases where the table name matches the
6154 " WHERE type IN ('table','view')"
6167 " WHERE type='index'"
6177 " WHERE type IN ('table','view')"
6184 " WHERE type='index'"
