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. |
Discuss this page in DocCommentXchange.
|
Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1 |