>Can you not deduce what you want using sqlite_sequence, as described
>in section 2.6.1 of

><https://www.sqlite.org/fileformat2.html#internal_schema_objects>

>?  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 
PRIMARY KEY.

>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
(
  y INTEGER,
  z TEXT,
  PRIMARY KEY(y)
);

Also identifies y as the INTEGER PRIMARY KEY but does not contain the spelling 
"INTEGER PRIMARY KEY" anywhere within it.




_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to