I'm using sqlite 3.2.8

I have a table:

create table lookups
(
  id integer,
  descr varchar(80),
  codetype integer,
  primary key(id)
);

when I use:

pragma index_list(lookups);

It returns nothing. However, if I change the id field to text instead of integer, then it shows:

0|sqlite_autoindex_lookups_1|1

So my question is:

when id is an integer, is there an index? If there is, why does it not show?

I see in the help that:
"the column is used internally as the actual key of the B-Tree for the table".

So, no actual index on the table?

But if "pragma index_list(lookups);" doesnt show one, how do I know its there?

Thank you,

-Andy

PS: if this duplicates, please forgive me (I tried sending from gmane.org the first time.

Reply via email to