15.00 - HELP VOLATILE TABLE - 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)

HELP VOLATILE TABLE

Volatile Table Attributes

Because the Session ID and Creator Name are identical for all volatile tables created within a given session, these attributes are not provided in the HELP VOLATILE TABLE report. Similarly, you can obtain information for the following volatile table attributes by performing a SHOW TABLE statement (see “SHOW object” on page 993).

  • Protection
  • Commit Option
  • Transaction Log Option
  •  

     

    Data Type

    Nullable

    Description

    Table Name

    VARCHAR(30)

    No

    The name of the volatile table.

    Table ID

    CHAR(16)

    No

    The internal system-assigned identifier for the table.

    Table Dictionary Name

    VARCHAR(128)

    No

    The attributes shown in this section are based upon and supersede the corresponding older Table Name attribute, while providing additional functionality.

    The older attribute is retained for compatibility with existing applications.

    For details, see the topics beginning with “Working with Object Name and Title Data in HELP Reports” on page 896.

    Table SQL Name

    VARCHAR(644)

    No

    Table Uescape

    VARCHAR(1)

    Yes