title: SQLite Schema Information Metadata
body: <p>I need to get column names and their tables in a SQLite database. What I need is a resultset with 2 columns: <code>table_name | column_name</code>. </p>
  
  <p>In MySQL, I'm able to get this information with a SQL query on database <code>INFORMATION_SCHEMA</code>. However the SQLite offers table <code>sqlite_master</code>: </p>
  
  <pre><code>sqlite&gt; create table students (id INTEGER, name TEXT);
  sqlite&gt; select * from sqlite_master;
    table|students|students|2|CREATE TABLE students (id INTEGER, name TEXT)
  </code></pre>
  
  <p>which results a DDL construction query (<code>CREATE TABLE</code>) which is not helpful for me and I need to parse this to get relevant information. </p>
  
  <p>I need to get list of tables and join them with columns or just get columns along with table name column. So <code>PRAGMA table_info(TABLENAME)</code> is not working for me since I don't have table name. I want to get all column metadata in the database.</p>
  
  <p>Is there a better way to get that information as a result set by querying database?</p>