Bootstrap FreeKB - SQLite - List tables in a database
SQLite - List tables in a database

Updated:   |  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 Buy Me A Coffee



Comments


Add a Comment


Please enter 48bc0f in the box below so that we can be sure you are a human.