This leaves you to parse the DDL from sqlite_master.
Doug

-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] 
Sent: Thursday, April 13, 2006 2:51 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] PRAGMA table_info

Marco Bambini <[EMAIL PROTECTED]> wrote:
> Using PRAGMA table_info(...) there is no way to know if a column is  
> declared as unique and/or autoincrement.
> Am I missing something?
> Is there a way to get these info?
> 

There is no pragma currently (that I recall) for finding 
if a column is unique or autoincrement.
--
D. Richard Hipp   <[EMAIL PROTECTED]>

Reply via email to