Query Volatile Tables in Teradata

Question

How to query Teradata database to see which volatile tables are at moment in it? I have tried with

    SELECT * FROM dbc.tables
WHERE DatabaseName = 'MyDB'

It did not list any of the present volatile tables.

Answer 1

Volatile Tables are only visible within the current session.

HELP VOLATILE TABLE; returns the list of VTs for the current session, but there's no easy way to get that info for VTs in other sessions. You might try to query DBQL or AccessLog for CREATE VOLATILE TABLE statements submitted by currently logged on sessions, when this logging is enabled.

Dieter