Also see How to list tables in SQLite3 database in Python
Use this command to list all the tables in a SQLite3 database using the sqlite3 command line tool:
sqlite3 [database file] "SELECT name FROM sqlite_master WHERE type='table' AND name != 'sqlite_sequence';"
Example:
$ sqlite3 /usr/share/command-not-found/commands.db "SELECT name FROM sqlite_master WHERE type='table' AND name != 'sqlite_sequence';" commands packages