The system table DOMAIN.DOMAINS contains information about all 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 | CLOB | BLOB | 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 (DEFAULT) 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 Otherwise NULL value |
DEFINITION |
CLOB |
Domain definition text |
CREATEDATE |
DATE |
Creation date of the domain |
CREATETIME |
TIME |
Creation time of the domain |
COMMENT |
CLOB |
Comment on the domain |