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

Teradata Database SQL Data Definition Language Detailed Topics

Product
Teradata Database
Release Number
15.00
Content Type
Programming Reference
Publication ID
B035-1184-015K
Language
English (United States)

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.