On Mar 6, 2004, at 3:25 PM, Richard Heyes wrote:
Is there a de-facto method of determining if a column is an INTEGER PRIMARY
KEY column (ie the auto increment type). Best I can come up with is checking
the type and if it has a unique index on it, which isn't definitive since it
could just be an integer column with a unique index.
I think if you do "PRAGMA table_info(<table>)" you get back a table of info for every column in the table. One of the fields is 'pk' and tells you whether or not that field is a primary key.
--------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
