how to get primary key column names for a given table?

All I know is only table name, and id value on which I want to perform query, but I do no开发者_Python百科t know what is id called in that table.

---

You can probably lookup the column name for the primary key column(s) using the answer to a quite similar question..

sqlite> pragma table_info(...)

It should also work programmatically, if needed.