>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
