How can I list temporary tables/views in SQLite? How can I list temporary tables/views in SQLite? sqlite sqlite

How can I list temporary tables/views in SQLite?


The main and temp databases are distinct, so you can just use the database name:

CREATE TABLE Albums(x);CREATE TEMPORARY VIEW Albums AS SELECT * FROM Albums;DROP VIEW IF EXISTS temp.Albums;DROP VIEW IF EXISTS temp.Albums;

Temporary objects are managed in sqlite_temp_master.