In a new database
<div class="remark-highlight"><pre class="language-sql"><code class="language-sql">sqlite> .databases
main: /Users/nindalf/.mcfly/history.db

sqlite> .table
commands schema_versions selected_commands

sqlite> .schema commands
CREATE TABLE commands( id INTEGER PRIMARY KEY AUTOINCREMENT ...

</code></pre></div>
For more, try <code>.help</code>, but I didn't see anything that seemed immediately helpful.

In a new database
sqlite> .databases
main: /Users/nindalf/.mcfly/history.db

sqlite> .table
commands           schema_versions    selected_commands

sqlite> .schema commands
CREATE TABLE commands( id INTEGER PRIMARY KEY AUTOINCREMENT ...



For more, try .help, but I didn't see anything that seemed immediately helpful.


Getting started with SQLite