Reference Manual
CHAPTER 15. System Tables
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.