DOMAINS
The system table DOMAIN.DOMAINS
contains
information about all domains.
|
CHAR(32) |
Name of the owner of the domain |
|
CHAR(32) |
Name of the domain |
|
CHAR(10) |
Data type of the domain (BOOLEAN | CHAR | DATE | FIXED | FLOAT | INTEGER | CLOB | BLOB | SMALLINT | TIME | TIMESTAMP) |
|
CHAR(8) |
Code attribute of domain (ASCII | BYTE | UNICODE) |
|
FIXED(4) |
Length or precision of the domain |
|
FIXED(3) |
Number of decimal places in domains of data type FIXED |
|
CHAR(254) |
Default value (DEFAULT) for domain |
|
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 |
|
CLOB |
Domain definition text |
|
DATE |
Creation date of the domain |
|
TIME |
Creation time of the domain |
|
CLOB |
Comment on the domain |