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

SQL Anywhere 12.0.0 » SQL Anywhere Server - SQL Reference » Views » System views


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.

Column name Data type Description
domain_id SMALLINT The unique number assigned to each data type. These numbers cannot be changed.
domain_name CHAR(128) The name of the data type normally found in the CREATE TABLE command, such as CHAR or INTEGER.
type_id SMALLINT The ODBC data type. This value corresponds to the value for data_type in the Transact-SQL-compatibility dbo.SYSTYPES table.
"precision" SMALLINT 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