Re: [sqlite] Accessing temporary tables

ubject: [sqlite] Accessing temporary tables I'd like to get some guidance on accessing and using temporary tables, i.e. those created using the TEMPORARY keyword. How do I get a list of any temporary tables in a database? They don't appear in the sqlite_master table. Once I have a list, can I use som

Re: [sqlite] Accessing temporary tables

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On 04/02/12 16:26, Pete wrote: > How do I get a list of any temporary tables in a database? There is a separate database named 'temp' that contains temporary tables. (The main database is named 'main' and you can omit its name.) sqlite> pragma

[sqlite] Accessing temporary tables

I'd like to get some guidance on accessing and using temporary tables, i.e. those created using the TEMPORARY keyword. How do I get a list of any temporary tables in a database? They don't appear in the sqlite_master table. Once I have a list, can I use some form of PRAGMA table_info to get a