> 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.
Sweet. Guess I should upgrade more often. :) Thanks! -- Richard Heyes --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]