SYS.TTABLES

The TTABLES table stores information about temporary tables associated with active sessions, including the name, the owner, the number of columns, the size of a row and the primary key (if any).

Specific column information is stored in the COLUMNS table.

Columns

Column name	Type	Descriptions
TBLNAME	TT_CHAR(31) NOT NULL	Table name
TBLOWNER	TT_CHAR(31) NOT NULL	Name of user who owns the table
OWNER	TT_INTEGER NOT NULL	Owner of table 0 - TimesTen system table 1 - user table
NUMVARY	TT_SMALLINT NOT NULL	Number of varying-length columns in table
NUMNULL	TT_SMALLINT NOT NULL	Number of nullable columns in table
NUMCOLS	TT_SMALLINT NOT NULL	Number of columns in table
LENGTH	TT_BIGINT NOT NULL	Length of inline portion of each row
NUMLOB	TT_SMALLINT NOT NULL	Number of LOB columns in table
NUMCOMPRESS	TT_SMALLINT NOT NULL	Number of columns compressed in table
TBLID	TT_BIGINT NOT NULL	TimesTen identifier for table
NUMTUPS	TT_BIGINT NOT NULL	Table cardinality This value is precise only when no INSERT or DELETE transactions are active. The value includes uncommitted inserts, but not uncommitted deletes. Consequently, the value of this field may be larger than the actual table cardinality.
MAXTUPS	TT_BIGINT NOT NULL	Maximum table cardinality
PRIMCNT	TT_SMALLINT NOT NULL	Number of columns in primary key (0 if none)
PRIMCOLS	BINARY (64) NOT NULL	Array of two-byte integer column numbers of primary key, mapped to binary
CACHEFLAG	BINARY(1) NOT NULL	Cache group flag 0 - Table is not in a cache group. 1 - Table is in a cache group.
PXLAFLAG	BINARY(1) NOT NULL	XLA persistence flag If set, indicates that persistent XLA has been enabled for this particular user table.
NUMPTNS	TT_SMALLINT NOT NULL	Total number of partitions. Valid value is 1.
CACHEGROUP	TT_BIGINT NOT NULL	ID of cache group that this table belongs to
OCACHEGROUP	TT_BIGINT NOT NULL	Reserved for internal use
MVID	TT_BIGINT NOT NULL	If the table is a view: ID of the associated row in the SYS.VIEWS system table
MVIDS	TT_VARCHAR(1024) NOT INLINE	If the table is a view detail table: ID of the array or the IDs of the rows in the SYS.VIEWS system table of the materialized views that reference this detail table
CGFKIDS	TT_VARCHAR (8192) NOT INLINE	Reserved for future use
PERMLTBLID	TT_INTEGER NOT NULL	The associated permanent table's ID
CVVERSIONNUM	TT_INTEGER NOT NULL	Reserved for internal use
REPNUMKEYCOLS	TT_SMALLINT NOT NULL	Number of columns in the replication key described by REPKEYCOLS
REPTSCOLNUM	TT_SMALLINT NOT NULL	Column number of the column used for replication's timestamp-based conflict checking
REPRETURNSERVICE	TT_CHAR(1) NOT NULL	Return service for this subscriber with respect to this replication element 'C' - RETURN COMMIT 'R' - RETURN RECEIPT '2' - RETURN TWOSAFE '\0' - NO RETURN services
REPRETURNBYREQUEST	BINARY(1) NOT NULL	Status of return service 0 - Return services are provided unconditionally. 1 - Return services are provided only by request. This field is ignored if REPRETURNSERVICE = '\0'.
REPUSERID	TT_BIGINT NOT NULL	User-defined identifier for table (set with the ttSetUserTableID built-in procedure)
REPKEYCOLS	BINARY(32) NOT NULL	Column numbers used by replication for unique identification of a row This is an array of two-byte integers, mapped to binary.
REPACCESS	TT_CHAR(1) NOT NULL	The access restrictions imposed by replication '-' - no access permitted 's'- may be read by read-only (SELECT) transactions 'r' - may be read by updating transactions 'w' - may be updated w => r and r => s
REPTSUPDATERULE	TT_CHAR(1) NOT NULL	The rule for maintaining the TS_COLUMN for a timestamp-based conflict detector '\0' - rule not defined 'U' - BY USER 'S' - BY SYSTEM (default)
CACHEDTBLPOS	TT_INTEGER NOT NULL	Reserved for future use
VALTBLIDS	VARBINARY(8000) NOT INLINE	If the table contains compressed columns: ID of an array, containing the IDs of the corresponding dictionary tables
MAXROWKEYBATCH	BINARY (80) NOT NULL	Reserved for internal use
LASTROWKEY	TT_BIGINT NOT NULL	Reserved for internal use
HDISTCOLS	BINARY (64) NOT NULL	Reserved for internal use
HDISTCNT	TT_SMALLINT NOT NULL	Reserved for internal use
ROWKEYLEN	TT_TINYINT NOT NULL	Reserved for internal use
ROWKEYOFF	TT_INTEGER NOT NULL	Reserved for internal use
VERSIONOFF	TT_INTEGER NOT NULL	Reserved for internal use
VERSIONNBOFF	TT_INTEGER NOT NULL	Reserved for internal use
DISTRIBUTIONMODE	TT_INTEGER NOT NULL	The distribution scheme for a global temporary table. TimesTen Scaleout distributes rows to where the global temporary table is instantiated. Valid in TimesTen Scaleout only.
DISTRIBUTIONTAG	TT_CHAR (31)	Reserved for internal use
VERSIONNBMASK	TT_TINYINT NOT NULL	Reserved for internal use