Cecil Westerhof <cldwester...@gmail.com> wrote: > The help says that .indices shows all indices. But it shows at least > not the PRIMARY KEY indices. > When using: > .indices > I get nothing.
Works for me: sqlite> create table t(x text primary key); sqlite> .indices t sqlite_autoindex_t_1 If you are talking about INTEGER PRIMARY KEY column, then no index is shown for it because none is created. See also http://sqlite.org/lang_createtable.html#rowid -- Igor Tandetnik _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users