_                    _
  ___ | |__   __ _ _______ | |_
 / _ \| '_ \ / _` |_  / _ \| __|
| (_) | | | | (_| |/ / (_) | |_
 \___/|_| |_|\__,_/___\___/ \__|

SQLite3 — usage and tips

Type .quit to exit.

sqlite3 [database] "COMMAND|QUERY"

  • .fullschema will retrieve all the tables and their fields from the db.
  • .tables will retrieve all the tables from the db.
  • .schema [table] will retrieve the fields from a table.

back to top

sql , mysql

- Archlinux manpages: sqlite3(1)

- SQLite

back to top

ohazot | about | ohazot.com <admin@ohazot.com>

This document applies to: linux , OpenBSD 7.8 | Created:2026-03-24|Updated:2026-03-24|