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 <[email protected]> To: [email protected] 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 [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
