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

.help                  # Help
.exit                  # Quit
.tables                # List all tables