2011/6/26 Kees Nuyt <k.n...@zonnet.nl>

> >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 ;)
>

Well I think it should at least be  documented. I caught me by surprise.

-- 
Cecil Westerhof
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to