17.00 - Example: Using AllTempTablesVX - Teradata Database

Teradata Vantageā„¢ - Data Dictionary

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
created_date
June 2020
category
Administration
Programming Reference
featnum
B035-1092-170K

After a global temporary table definition is created, you can use the INSERT statement to create a local instance of the global temporary table for use during the session.

The following statement shows all temporary tables materialized by the login user in the system:

SELECT * FROM DBC.AllTempTablesVX;