Contents Index SYSCONSTRAINT system table SYSEVENT system table

ASA SQL Reference
  System Tables

SYSDOMAIN system table


Column name Column type Column constraint Table constraints
domain_id SMALLINT NOT NULL Primary key
domain_name CHAR(128) NOT NULL
type_id SMALLINT NOT NULL
precision SMALLINT

Each of the predefined data types (sometimes called domains) is assigned a unique number. The SYSDOMAIN table is provided for informational purposes, to show the association between these numbers and the appropriate data types. This table is never changed.

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.


Contents Index SYSCONSTRAINT system table SYSEVENT system table