Re: [sqlite] querying schema for integer primary key

2005-04-20 Thread Harald Fernengel
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 whethe

Re: [sqlite] querying schema for integer primary key

2005-04-20 Thread Witold Czarnecki
Try: sqlite>.schema TableName ...will display table definition. Best regards, Witold

[sqlite] querying schema for integer primary key

2005-04-20 Thread 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