15.10 - AllTempTablesV[X] - Teradata Database

Teradata Database Data Dictionary

Product
Teradata Database
Release Number
15.10
Content Type
Administration
User Guide
Publication ID
B035-1092-151K
Language
English (United States)

Operations

DBC

 

View Column

Data Type

Format

Source Table.Column

HostNo

SMALLINT

NOT NULL

---,--9 (explicit)

TempTables.HostNo (Composite NUPI)

SessionNo

INTEGER

NOT NULL

--,---,---,--9 (explicit)

TempTables.SessionNo (Composite NUPI)

UserName

VARCHAR(128)

UNICODE

NOT CASESPECIFIC

NOT NULL

X(128)

SessionTbl.UserName

B_DatabaseName

VARCHAR(128)

UNICODE

UPPERCASE

NOT CASESPECIFIC

NOT NULL

X(128)

Dbase.DatabaseNameI (UPI)

B_TableName

VARCHAR(128)

UNICODE

UPPERCASE

NOT CASESPECIFIC

NOT NULL

X(128)

TVM.TVMNameI (Composite UPI)

E_TableId

BYTE(6)

NOT NULL

X(12)

TempTables.TableId

After a global temporary table definition is created, you can use the INSERT statement to create a local instance of the global temporary table for use during the session.

The following statement shows all temporary tables materialized by the login user in the system:

==> SELECT * FROM DBC.AllTempTablesVX;