Quoting Ralf Junker <ralfjun...@gmx.de>: > pragma table_info(table); > > In SQLite, this SQL returns all columns defined for table along with > their types. Check the "pk" result column to see if a named column > is a PRIMARY KEY column. >
I see. Looks like we can internally convert all columns defined as INTEGER with a non-NULL entry in the pk column (is this correct? the docs are a bit terse about this) back to INTEGER PRIMARY KEY. Thanks Markus -- Markus Hoenicka markus.hoeni...@cats.de (Spam-protected email: replace the quadrupeds with "mhoenicka") http://www.mhoenicka.de _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
