This may also shed some light for you. The accepted answer and possibly the one below it if you are on .NET
http://stackoverflow.com/questions/763516/information-schema-columns-on-sqlite HTH, Best, Karl DeSaulniers Design Drumm http://designdrumm.com > On Aug 20, 2016, at 5:30 AM, Karl DeSaulniers <k...@designdrumm.com> wrote: > > Hey Ratin, > Have you looked into the table column named 'pk' inside table_info? > That is where a column is indicated to be a primary key or not. > > Best, > > Karl DeSaulniers > Design Drumm > http://designdrumm.com <http://designdrumm.com/> > > > > >> On Aug 18, 2016, at 6:51 PM, Ratin <rat...@gmail.com> wrote: >> >> Hi Karl, Thanks a lot for your response, I think INFORMATION_SCHEMA is not >> available for sqlite database. I had to built up the whole query with php >> using PRAGMA table_info(tablename), looking at the pk entry, when its 1, get >> the column name, and then update the sql statement based on that. A bit of >> work, wouldve been much simpler if a method was provided, but oh well .. >> >> Thanks again >> >> Ratin >> >> On Thu, Aug 18, 2016 at 2:53 PM, Karl DeSaulniers <k...@designdrumm.com >> <mailto:k...@designdrumm.com>> wrote: >> Hi Ratin, >> Going to take a stab at this one. >> Have you looked into INFORMATION_SCHEMA.COLUMNS for your query? >> Might be where you want to look for what you are trying. >> Sorry can't help more. >> >> Best, >> >> Karl DeSaulniers >> Design Drumm >> http://designdrumm.com <http://designdrumm.com/> >> >> >> >> >>> On Aug 18, 2016, at 1:27 PM, Ratin <rat...@gmail.com >>> <mailto:rat...@gmail.com>> wrote: >>> >>> I'm writing the generic get that works on different tables having different >>> primary keys but the argument of get is always the primary key , i.e. get >>> request is - >>> >>> get (column name, value) >>> >>> the value is always the primary key value. >>> >>> It looks like it would be a pretty standard method but I cant find a method >>> like that. Anybody have any clue? >>> >>> Thanks >>> >>> Ratin >> >> >> -- >> PHP Database Mailing List (http://www.php.net/ <http://www.php.net/>) >> To unsubscribe, visit: http://www.php.net/unsub.php >> <http://www.php.net/unsub.php> >> >> > -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
