HELP VOLATILE TABLE Example | Teradata Vantage - 17.05 - Example: HELP VOLATILE TABLE - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Advanced SQL Engine
Teradata Database
Release Number
January 2021
Content Type
Programming Reference
Publication ID
English (United States)

Suppose you need to know the Table ID of the volatile table sales_temp. To determine this information, you enter the following request.

     HELP VOLATILE TABLE sales_temp;

The result shows that the Table ID for this table is 40C00E000000.

           Table Name Sales_temp
             Table Id 40C00E000000
Table Dictionary Name Sales_temp
       Table SQL Name Sales_temp
        Table Uescape ?