Tables in an SQLite database can be listed using the following command via the SQLite client:

.tables

This can be done directly in the SQLite client or from the shell command-line like this:

$ echo .tables | sqlite3 perfmetrics.db
iostat   loadavg  meminfo  mpstat   uptime   vmstat

Show tables using SQL query

Another way of listing tables is by querying sqlite_schema with an SQL query.

Example:

SELECT name
FROM sqlite_schema
WHERE
    type ='table' AND
    name NOT LIKE 'sqlite_%';