Thomas' Tech Tips

How to list tables in an SQLite Database

24 May 2023 - Thomas Damgaard

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


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.


FROM sqlite_schema
    type ='table' AND
    name NOT LIKE 'sqlite_%';
Filed under: databases, howto, sql, sqlite, tips

Back to article list