sqlite3 Frequent Commands

Tables and Schema

.tables
.schema user

Pretty Print / Columns / Headers

Column mode turns on columns all on it’s own.

.headers on

ward_id|ward_num
1|6

.mode column
ward_id  ward_num
-------  --------
1        6

.width 10 10
ward_id     ward_num
----------  ----------
1           6