SQLite Forum

Retrieve list of tables
Login
I use ``SELECT name FROM sqlite_master WHERE type='table'`` when I need a list of all tables within a database. This list includes internal tables as well, e.g. "sqlite_sequence". The ".tables" CLI command does not.

Is there a more convenient way which does not need any filtering (there seems to be no pragma either)? I'm not sure whether internal tables always start with "sqlite_". How about temporary tables?

If not, may I suggest the beautiful "SHOW TABLES" statement from MySQL. Simple as could be, very helpful, easy to remember, and working not only in CLI but everywhere.