title: SQLite query to find primary keys
body: <p>In SQLite I can run the following query to get a list of columns in a table:</p>
  
  <pre><code>PRAGMA table_info(myTable)
  </code></pre>
  
  <p>This gives me the columns but no information about what the primary keys may be. Additionally, I can run the following two queries for finding indexes and foreign keys:</p>
  
  <pre><code>PRAGMA index_list(myTable)
  PRAGMA foreign_key_list(myTable)
  </code></pre>
  
  <p>But I cannot seem to figure out how to view the primary keys. Does anyone know how I can go about doing this?</p>
  
  <p>Note: I also know that I can do:</p>
  
  <pre><code>select * from sqlite_master where type = 'table' and name ='myTable';
  </code></pre>
  
  <p>And it will give the the create table statement which shows the primary keys. But I am looking for a way to do this without parsing the create statement.</p>