title: information_schema.columns on sqlite
body: <p>I would like to do a query like next:</p>
  
  <pre><code>SELECT table_name, column_name, data_type, is_nullable, ... 
  FROM information_schema.columns
  </code></pre>
  
  <p>on a sqlite database.</p>
  
  <p>I checked </p>
  
  <pre><code>PRAGMA table_info(table_name); 
  </code></pre>
  
  <p>but doesn't suit my needs, just check fields for <em>one</em> table.</p>
  
  <p>I checked </p>
  
  <pre><code>select * from sqlite_master where type = 'table';
  </code></pre>
  
  <p>But this just gets table names and creation query.</p>
  
  <p>Is there any way to "join" these to methods? or any other suggestion or ideas? tx</p>