On Sun, 26 Jun 2011 11:24:31 +0200, Cecil Westerhof <cldwester...@gmail.com> wrote:
>I have the following (beside some others) table defined: > CREATE TABLE IF NOT EXISTS weights ( > id INTEGER PRIMARY KEY, > categoryID INTEGER NOT NULL, > measureDate DATE DEFAULT (DATE('now')), > weight FLOAT NOT NULL, > fat FLOAT, > water FLOAT, > muscle FLOAT, > > UNIQUE ( > categoryID, > measureDate > ) > ); > >When using > .indices >but when using: > .indices weights >I get: > sqlite_autoindex_weights_1 >Should it not be shown in the first instance also? It's a matter of taste if it should. .indices will show indices which are created explicitly with a CREATE INDEX statement. .indices tablename will also show the automatically generated indices, needed to implement UNIQUE constraints. I would call this both a feature and a documentation bug ;) -- ( Kees Nuyt ) c[_] _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users