2011/6/6 Igor Tandetnik :
>>> 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.
>>
>> Th
Cecil Westerhof wrote:
> 2011/6/6 Igor Tandetnik :
>> 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 previo
2011/6/6 Igor Tandetnik :
> Cecil Westerhof 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
Something went wrong, so again.
The help says that .indices shows all indices. But it shows at least
not the PRIMARY KEY indices.
When using:
.indices
I get nothing.
When using:
.indices weights
I get:
sqlite_autoindex_weights_1
--
Cecil Westerhof
Cecil Westerhof 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 IN
The help says that .indices shows all indices. But it shows at least
not the PRIMARY KEY indices.
When using:
.indices
I get nothing.
When using:
--
Cecil Westerhof
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-b
6 matches
Mail list logo
