2011/6/6 Igor Tandetnik <itandet...@mvps.org>: > 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
That is what I am talking about. Something went wrong with my previous e-mail. The strange thing is that the INTEGER PRIMARY key is not shown when using .indices without an argument, but is shown when I give a table. -- Cecil Westerhof _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users