SQLite 3 cheatsheet

SQLite 3: Inspecting the database

7 common SQLite 3 tasks.

List tables

Show the tables in the database.

.tables

Print the CREATE statements for a table and its indexes.

.schema users

Print the CREATE statements for everything.

.schema

Show the indexes on a table.

.indexes users

Show column names, types and keys with a pragma.

PRAGMA table_info(users);

Show the foreign keys declared on a table.

PRAGMA foreign_key_list(orders);

Show the databases and files in use.

.databases