rsk82
Reputation: 29407
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 not know what is id called in that table.
Upvotes: 6
Views: 8739
Answers (1)
gnab
Reputation: 9571
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.
Upvotes: 6
Related Questions
- How to get a list of column names on Sqlite3 database?
- Is there a way to get a list of column names in sqlite?
- How to get a list of column names
- SQLite query to find primary keys
- How to get the primary keys column of a table in SQLite
- How to get columns' name from a table in sqlite3 database using python3?
- How to find out primary keys of a table in android sqlite programatically?
- Using sqlite3 ,How to only get the primary keys from a table with SELECT
- What is universal SQL way to obtain names of columns in Primary Key?
- Get table's primary key's name