Re: [sqlite] is it possible to return primary key column from given table ?

P Kishor-3 wrote: > what is the name of the column? Is it '--idcolumn--'? That was only example written when I didn't know even for what syntax to look for. Now problem comes to how to run SELECT against PRAGMA table_info(tblname). Only way out of this that I found is to run regex against the

Re: [sqlite] is it possible to return primary key column from given table ?

On Mon, May 3, 2010 at 2:14 AM, yogibabu wrote: > > like this: SELECT --idcolumn-- FROM `table` what is the name of the column? Is it '--idcolumn--'? Are the leading and trailing '--' part of the name? Remember that leading '--' is used as SQL comments. If that is indeed

Re: [sqlite] is it possible to return primary key column from given table ?

On 3 May 2010, at 8:14am, yogibabu wrote: > like this: SELECT --idcolumn-- FROM `table` If you always want to use a unique integer to refer to a record, you can ask for the column called '_rowid_' even if you didn't define one. You can use this in SELECT and UPDATE commands, as long as you

[sqlite] is it possible to return primary key column from given table ?

like this: SELECT --idcolumn-- FROM `table` -- View this message in context: http://old.nabble.com/is-it-possible-to-return-primary-key-column-from-given-table---tp28432175p28432175.html Sent from the SQLite mailing list archive at Nabble.com. ___