SYS.COLUMNS

The COLUMNS table describes every column in every table in the data store, including the name of the column, the type of the column and whether the column is nullable.

Columns

Column name	Type	Description
ID	TT_INTEGER NOT NULL for 32-bit systems; TT_BIGINT NOT NULL for 64-bit systems	TimesTen identifier of -column's table.
COLNUM	TT_SMALLINT NOT NULL	Ordinal number of column in table (starting at 1).
COLNAME	TT_CHAR (31) NOT NULL	Column name.
COLOPTIONS	BINARY (1) NOT NULL	Column specification flags: 0x01 - column is in a primary key. 0x02 - column value is varying-length (VARCHAR[2], NVARCHAR[2],VARBINARY). 0x04 - column value can be NULL. 0x08 - column values are unique.
COLTYPE	TT_INTEGER NOT NULL	Data type of column 1 TT_SMALLINT 2 TT_INTEGER 3 BINARY_FLOAT 4 BINARY_DOUBLE 5 TT_CHAR 6 TT_VARCHAR 7 BINARY 8 VARBINARY 11 TT_DECIMAL 12 TT_NCHAR 13 TT_NVARCHAR 14 TT_DATE 15 TIME 16 TT_TIMESTAMP 20 TT_TINYINT 21 TT_BIGINT 22 TT_VARCHAR (inline) 23 VARBINARY (inline) 24 TT_NVARCHAR (inline) 25 NUMBER 26 CHAR 27 VARCHAR2 28 NCHAR 29 NVARCHAR2 30 DATE 31 TIMESTAMP 32 VARCHAR2 (inline) 33 NVARCHAR2 (inline) 34 ROWID Note: If you are using TimesTen type mode, for information on COLTYPE, refer to documentation from previous releases of TimesTen. For information on TimesTen type mode, see "TimesTen type mode (backward compatibility)".
TYPE_ATTR	TT_INTEGER NOT NULL	Reserved for internal use.
COLLEN	TT_INTEGER NOT NULL for 32-bit systems; BIGINT NOT NULL for 64-bit systems	Length of the column (maximum length for varying-length columns).
INLINELEN	TT_INTEGER NOT NULL	Identifies how many bytes a given column contributes to the inline width of a row.
REPUSERID	TT_INTEGER NOT NULL	User-defined identifier for column (set with -`ttSetUserColumnID` built-in function).
DEFAULTVALSTR	TT_VARCHAR (409600) NOT INLINE	The default column value.
CHAR_USED	TT_CHAR (1)	Indicates the semantics for the column: 'B' for BYYE 'C' for CHAR NULL for non-character columns