Hi, On Wednesday 20 April 2005 14:25, Harald Fernengel wrote: > does anyone know how I can query an existing database schema to figure out > whether a integer in a table is a "integer primary key" or just a plain > "integer"?
...replying to myself... The pragma table_info returns the info whether a field is a primary key or not. This is not documented yet on http://www.sqlite.org/pragma.html#schema Best regards, Harald
