On Sun, 26 Jun 2011 11:24:31 +0200, Cecil Westerhof
<[email protected]> 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
[email protected]
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
