How can I identify what are the GTT or volatile tables created during a session?
For VT you can use
help volatile table
Also you can read the lines:
realize this is an old thread, but how do i find a VT within a stored procedure
eg i have a SP drop_table(db_name, table_name) that i want to drop any type of table (normal, GTT or VT). it looks in dbc.tables for the first 2 types and drops them if they exist. Is there anywhere I can look for VT?