Reference Guide > TDV and Business Directory System Tables > SYS_TRANSIENT_TABLES
 
SYS_TRANSIENT_TABLES
Used to hold data for the MPP engine.
Column
TDV JDBC Data Type
Nullable
Description
TABLE_ID
INTEGER
 
 
TABLE_NAME
VARCHAR(255)
 
 
TABLE_TYPE
VARCHAR(255)
 
The only possible value of this column is "TABLE".
CARDINALITY
INTEGER
Yes
Number of rows in the table since last introspection. If the CARDINALITY is unknown then the value is null.
SCHEMA_ID
INTEGER
Yes
 
SCHEMA_NAME
VARCHAR(255)
Yes
 
CATALOG_ID
INTEGER
Yes
 
CATALOG_NAME
VARCHAR(255)
Yes
 
DATASOURCE_ID
INTEGER
 
 
DATASOURCE_NAME
VARCHAR(255)
 
 
ANNOTATION
 
Yes
 
OWNER_ID
INTEGER
 
 
CID
INTEGER
 
Commit ID
TABLE_CREATOR_ID
INTEGER
 
 
TABLE_CREATION_TIMESTAMP
BIGINT
 
 
TABLE_MODIFIER_ID
INTEGER
 
 
TABLE_MODIFICATION_TIMESTAMP
BIGINT
 
Timestamp of the last modification of this table.
GUID
VARCHAR(36)
 
128 bit identifier that is practically unique