 <p>To list all tables in a database</p> <pre><code>SELECT name FROM sqlite_master WHERE type='table' </code></pre> <p>To list all columns in a table</p> <pre><code>pragma table_info(table_name) </code></pre>