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||Column 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.|
PRIMARY KEY (domain_id)
|Send feedback about this page via email or DocCommentXchange||Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0|