sqlite - programmatically determine primary key(s)

Question

I need to programatically determine what the primary key field(s) are for a given sqlite table (using sqlite api, not command line).

I can get a list of tables and a list of columns, but only see the column type using the Column_Type() function. Need to know if a given column is the primary key (or part of the primary key if a compound key is used).

Answer 1

sqlite3_table_column_metadata