>Can you not deduce what you want using sqlite_sequence, as described
>in section 2.6.1 of
>? This allows you to distinguish a primary key which happens to be
>an integer from an |NTEGER PRIMARY KEY.
No it does not. It only identifies AUTOINCREMENT INTEGER PRIMARY KEY since
only AUTOINCREMENT fields are in sqlite_sequence, only if a row has been
inserted, and AUTOINCREMENT fields just happen to also have to be INTEGER
>Another useful thing might be to find the command used to create the
>table from the sqlite_master table and see whether it includes the
>text "INTEGER PRIMARY KEY".
Except that will not work.
create table x
Also identifies y as the INTEGER PRIMARY KEY but does not contain the spelling
"INTEGER PRIMARY KEY" anywhere within it.
sqlite-users mailing list