Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 10.0.1 » SQL Anywhere Server - SQL Reference » Views » System views in Sybase Central

SYSDEPENDENCY system view Next Page

SYSDOMAIN system view


The SYSDOMAIN system view records information about built-in data types (also called domains). The contents of this view does not change during normal operation. The underlying system table for this view is ISYSDOMAIN.

Columns
Column name Column type Column constraint
domain_id SMALLINT NOT NULL
domain_name CHAR(128) NOT NULL
type_id SMALLINT NOT NULL
"precision" SMALLINT

domain_id    The unique number assigned to each data type. These numbers cannot be changed.

domain_name    The name of the data type normally found in the CREATE TABLE command, such as CHAR or INTEGER.

type_id    The ODBC data type. This value corresponds to the value for 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.

Constraints on underlying system table

PRIMARY KEY (domain_id)