sqlite3 file.db
.tables
.quit
select * from book;
PRAGMA table_info(book);
.schema book;
show column headers: .headers ON
open a database
sqlite3 my_stuff_database.db
print database structure
.schema
print database structure and data
.dump
turn on / off column names in results
.explain on
.explain off
show databases
.databases
show tables
.tables
show current settings
.show
show headings
.header on
show columns
.mode column
show timer (how long query took)
.mode timer
quit
.quit
show index
.indices [table]
rename a table
alter table department rename to dept;