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 have an index. So
my question is where is the index for the 'tag' column?
This is the complete CREATE TABLE SQL.
CREATE TABLE tags
(
tag text primary key,
description text,
date_created text DEFAULT CURRENT_TIMESTAMP,
style text
)
Thanks.
--
Best regards,
Neville Franks, http://www.surfulater.com http://blog.surfulater.com
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
