15.00 - SHOW TABLE Support for Global Temporary and Volatile Tables - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

prodname
Teradata Database
vrm_release
15.00
category
Programming Reference
featnum
B035-1184-015K

SHOW TABLE Support for Global Temporary and Volatile Tables

When you specify the keyword TEMPORARY, the table definition for the materialized global temporary table in the current session is displayed; else the definition for the base global temporary table is displayed.

The keyword VOLATILE is reported when the requested table is a volatile table.