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
.