Each database has a SQLITE_TEMP_MASTER table for temp tables and temp triggers. See http://www.sqlite.org/faq.html#q7
Best regards, Peter ________________________________ From: Pete <p...@mollysrevenge.com> To: sqlite-users@sqlite.org Sent: Sat, February 4, 2012 5:26:21 PM Subject: [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 list of the columns in a temp table? Thanks, -- Pete _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users