SQLite Knowledge Base
Aus Matts Wiki
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 |
