SYS.TABLES

The TABLES table stores information about the tables in the data store, including the name, the owner, the number of columns, the size of a row and the primary key (if any). The TABLES table also stores information on system tables.

Specific column information is stored in the COLUMNS table.

Columns

Column name	Type	Description
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_INTEGER NOT NULL for 32-bit systems; TT_BIGINT NOT NULL for 64-bit systems	Length of in-line portion of each row.
TBLID	TT_INTEGER NOT NULL for 32-bit systems; TT_BIGINT NOT NULL for 64-bit systems	TimesTen identifier for table.
NUMTUPS	TT_INTEGER NOT NULL for 32-bit systems; TT_BIGINT NOT NULL for 64-bit systems	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_INTEGER NOT NULL for 32-bit systems; TT_BIGINT NOT NULL for 64-bit systems	Maximum table cardinality.
PRIMCNT	TT_SMALLINT NOT NULL	Number of columns in primary key (0 if none).
PRIMCOLS	BINARY (32) NOT NULL	Array of 2-byte integer column numbers of primary key, mapped to binary.
CACHEFLAG	BINARY (1) NOT NULL	1 - if the table is in a cache group, 0 otherwise.
XLAFLAG	BINARY (1) NOT NULL	If set, updates to this table should be transmitted to the transaction log API.
PXLAFLAG	BINARY (1) NOT NULL	If set, indicates that persistent XLA has been enabled for this particular user table.
CACHEGROUP	TT_INTEGER NOT NULL for 32-bit systems; TT_BIGINT NOT NULL for 64-bit systems	ID of cache group that this table belongs to.
MVID	TT_INTEGER NOT NULL for 32-bit systems; TT_BIGINT NOT NULL for 64-bit systems	If the table is a VIEW, indicates the ID of the associated row in the VIEWS system table
MVIDS	TT_VARCHAR(1024) NOT INLINE	If the table is a VIEW detail table, indicates the ID of the array of the Ids of the rows in the VIEWS system table of the materialized views that reference this detail table.
PERMLTBLID	TT_INTEGER NOT NULL	The associated permanent table's ID.
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	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 -`ttSetUserTableID` built-in function).
REPKEYCOLS	BINARY (32) NOT NULL	Column numbers used by replication for unique identification of a row. (an array of 2-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)
CACHETBLPOS	TT_INTEGER NOT NULL	Reserved for future use