DOMAINS 
Definition
The system table DOMAINS contains information about all domains.
Structure
DOMAINS
OWNER |
CHAR(32) |
Name of the owner of the domain |
DOMAINNAME |
CHAR(32) |
Name of the domain |
DATATYPE |
CHAR(10) |
Data type of the domain (BOOLEAN | CHAR | DATE | FIXED | FLOAT | INTEGER | LONG | SMALLINT | TIME | TIMESTAMP) |
CODETYPE |
CHAR(8) |
Code attribute of domain (ASCII | BYTE | UNICODE) |
LEN |
FIXED(4) |
Length or precision of the domain |
DEC |
FIXED(3) |
Number of decimal places in domains of data type FIXED |
DEFAULT |
CHAR(254) |
Default value for domain |
DEFAULTFUNCTION |
CHAR(12) |
Name, if the DEFAULT value is one of the following
value specifications: NULL | USER | USERGROUP | SYSDBA | UID | DATE | TIME |
TIMESTAMP | UTCDATE | TIMEZONE | UTCDIFF | TRUE | FALSE | TRANSACTION |
DEFINITION |
LONG |
Domain definition text |
CREATEDATE |
DATE(10) |
Creation date of the domain |
CREATETIME |
TIME(8) |
Creation time of the domain |
COMMENT |
LONG |
Comment on the domain |
See also:
Evaluating System Tables, DOMAINS
SQL Reference Manual, Data Type (data_type), Specification of Values (extended_value_spec)