SQLite - List tables in a database
by
Jeremy Canfield |
Updated: February 13 2023
| SQLite articles
The .tables command can be used to list the tables in a database. In this example, the example.db contains a table named users.
~]$ sqlite3 /path/to/example.db
SQLite version 3.34.1 2021-01-20 14:10:07
Enter ".help" for usage hints.
sqlite> .tables
users
Or like this, as a oneliner command.
~]$ sqlite3 /path/to/example.db ".tables"
users
Did you find this article helpful?
If so, consider buying me a coffee over at 