SQLite Forum

Retrieve list of tables
Login
> I'm not sure whether internal tables always start with "sqlite_".

I am pretty sure I have seen that documented. Moreover, you are not allowed to create a table whose name starts with `sqlite_` yourself; you get an error message if you try.

> How about temporary tables?

They are listed in `temp.sqlite_master`.