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
Otherwise NULL value

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)