Sqlite Cheat Sheet

This is from command line shell for sqlite.

1. Open sqlite database

$ sqlite3 db/development.sqlite3

2. List down tables

sqlite> .tables

3. Look at the schema

sqlite> .schema

4. Exit

sqlite> .exit