title: How to list declared temporary tables in DB2
body: <p>You can created session temporary tables in DB2 using the <a href="http://pic.dhe.ibm.com/infocenter/dzichelp/v2r2/topic/com.ibm.db2z9.doc.sqlref/src/tpc/db2z_sql_declareglobaltemptable.htm" rel="nofollow"><code>DECLARE GLOBAL TEMPORARY TABLE</code></a> statement. Is there any way to list all the tables that currently exist in the session's <code>SESSION</code> schema? Note <em>declared</em> global temporary tables do not exist in <code>SYSIBM.SYSTABLES</code>.</p>