Wednesday, April 22, 2020

sqlite cheat sheet

List all tables
.table

Show a table schema
.schema [app name]_[model name] --indent

Leave sql console
.exit

Dump data
.output [project].sql
.dump
.exit

No comments: