sqlite3 dev.db '.tables'

Category: Web App Development

sqlite3 dev.db '.tables'

List the tables in a SQLite dev database

Prints every table name stored in dev.db, the fastest orientation when opening an unfamiliar database. The dot command runs inside the sqlite3 shell. Use .schema users to see a table's columns and indexes.
Looking for more? Search all 7,657 commands — works offline, in English or Spanish, and fixes typos.