Lines Matching refs:WHERE
659 "UPDATE", "USING", "VACUUM", "VALUES", "VIEW", "VIRTUAL", "WHEN", "WHERE",
2133 " WHERE type='table'\n"
2899 ** rowids on tables where the rowid is inaccessible because there are other
2911 " WHERE origin='pk'", zTab);
3153 ".mode MODE ?TABLE? Set output mode where MODE is one of:\n"
3899 " WHERE %s", zWhere);
3926 " WHERE %s ORDER BY rowid DESC", zWhere);
4043 "SELECT count(*) FROM %s WHERE type='table'" },
4045 "SELECT count(*) FROM %s WHERE type='index'" },
4047 "SELECT count(*) FROM %s WHERE type='trigger'" },
4049 "SELECT count(*) FROM %s WHERE type='view'" },
4259 ** function returns the string " COLLATE <parent-collation>", where
4323 ** "EXPLAIN QUERY PLAN SELECT rowid FROM child_table WHERE child_key=?"
4354 " 'EXPLAIN QUERY PLAN SELECT rowid FROM ' || quote(s.name) || ' WHERE '"
4364 " (SELECT name FROM pragma_table_info(f.[table]) WHERE pk=seq+1)"
4487 raw_printf(stderr, "Where sub-commands are:\n");
4748 "WHERE sql NOT NULL AND type=='table' AND name!='sqlite_sequence'"
4752 "WHERE name=='sqlite_sequence'"
4756 "WHERE sql NOT NULL AND type IN ('index','trigger','view')", 0
4762 "WHERE tbl_name LIKE %Q AND type=='table'"
4768 "WHERE sql NOT NULL"
4854 "WHERE type!='meta' AND sql NOTNULL AND name NOT LIKE 'sqlite_%' "
4862 " WHERE name GLOB 'sqlite_stat[134]'",
5112 " WHERE name='%q' AND type='index'", azArg[1]);
5588 "WHERE lower(tbl_name) LIKE %Q"
5600 "WHERE type!='meta' AND sql NOTNULL AND name NOT LIKE 'sqlite_%' "
6023 " WHERE type='table' AND coalesce(rootpage,0)>1"
6028 " WHERE type='table' AND coalesce(rootpage,0)>1"
6171 ** main and all attached databases where the table name matches the
6176 " WHERE type IN ('table','view')"
6189 " WHERE type='index'"
6199 " WHERE type IN ('table','view')"
6206 " WHERE type='index'"
