CREATE TABLE SYS.SYSDOMAIN ( domain_id SMALLINT NOT NULL, domain_name CHAR(128) NOT NULL, type_id SMALLINT, precision SMALLINT, PRIMARY KEY ( domain_id ) )
Each of the predefined data types (also called domains) in Sybase IQ is assigned a unique number. The SYSDOMAIN table is provided for informational purposes to show the association between these numbers and the appropriate data type. This table is never changed by Sybase IQ.
domain_id The unique number assigned to each data type. These numbers cannot be changed.
domain_name A string containing the data type normally found in the CREATE TABLE command, such as char or integer.
type_id The ODBC data type. This corresponds to “data_type” in the Transact-SQL-compatibility DBO.SYSTYPES table.
precision The number of significant digits that can be stored using this data type. The column value is NULL for non-numeric data types.
