SYSDOMAIN system table
1006
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.
To Next Page
Loading...