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 ?