title: Get column name and type within python sqlite3
body: <p>I am  working with sqlite in python. I want to get column type AND column name in a tuple so that I can work with it.</p>
  
  <p>Eg :</p>
  
  <pre><code>CREATE TABLE table(
      A  INTEGER
      B  TEXT
      C  REAL);
  </code></pre>
  
  <p>I know that I can get column names using <code>sqlite_master</code> but I cant figure out how to extract column type along with it.</p>
  
  <p>For eg: Get <code>[(A,INTEGER), (B, TEXT), (C,REAL)]</code> or anything that has column name and type.</p>
  
  <p>Any help is appreciated.
  Thank you</p>