SQLite Knowledge Base

This article contains basic knowledge, commands and how to's for SQLite.

SQLite is the most used database engine in the world.

General Information

Open database.sqlite with sqlite CLI client:

sqlite database.sqlite

Within SQLite CLI interface

Command	Description
.help	Help
.exit	Quit
.tables	List tables in database
.schema [<tablename>]	Show database table description, optionally for a given table name