<[EMAIL PROTECTED]> wrote : > Bertrand Mansion wrote: >> Hi, >> >> I have been through the archives on yahoo groups and found a mail that said >> the current way to find the primary key in sqlite is to write your own sql >> parser. This was back in May 2003. >> >> Is this still the only way ? >> This looks tough to achieve, there seems to be so many things to take into >> consideration. Any pointers or sample code would be appreciated. :) >> > > The 6th column of the result of the TABLE_INFO pragma is true > for primary key columns and false for other columns.
Thanks Richard, that worked :) It might be a good idea to add that in the documentation or in a changelog (a bit late now...) as I was actually using 2.8.6 and it didn't have this feature. Unless I missed something of course... Happy holidays, Bertrand Mansion Mamasam --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
