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
Try:
sqlite>.schema TableName
...will display table definition.
Best regards,
Witold
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
3 matches
Mail list logo