Jens,
Thanks for that. I incorrectly assumed because the index was named
xxx_tags it wasn't for the 'tag' column, but related to the table,
which is named 'tags'.
I had read the content you referred to.
Thursday, February 21, 2008, 11:11:19 PM, you wrote:
JM> Am 21.02.2008 um 10:30 schrieb
Am 21.02.2008 um 10:30 schrieb Neville Franks:
> I have created a table with a column: tag text primary key
>
> When I do:
> sqlite> .indices tags
> sqlite_autoindex_tags_1
>
> I only see the one index which I assume is for the ROWID clm.
No, this is the index for your 'tag' column as can be
I have created a table with a column: tag text primary key
When I do:
sqlite> .indices tags
sqlite_autoindex_tags_1
I only see the one index which I assume is for the ROWID clm. I have
inserted a row into the table, in case that is relevant.
My understanding is that a primary key column will
3 matches
Mail list logo