title: Is there a way to order the result of a sqlite PRAGMA foreign_key_list() query by the order, the columns in the table the query is taken on, appear?
body: <p>I want to programmatically add an index to a sqlite table if it has more lines than a set limit size. I want to add the index to all columns which have a foreign key, to get those, I use</p>
  
  <pre><code>PRAGMA foreign_key_list(myTable)
  </code></pre>
  
  <p>where I use the <code>from</code> column to get the columns from my table which have a foreign key. 
  Since the order of a index with several columns is important I want to order them in the order they appear in the table. Is there a way to find the order within this <code>PRAGMA</code>query (and how), or do I have to make another query (<code>PRAGMA table_info(myTable)</code>) and find the order programmatically?</p>
  
  <p>EDIT: working with .db3 files. </p>