[sqlite] querying schema for integer primary key

[Harald Fernengel]

Hi,

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"?

Thanks,
Harald