Show TOC

Object documentationDOMAINS Locate this document in the navigation structure

 

The system table DOMAIN.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 | 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

More Information

Evaluating System Tables, DOMAINS

SQL Reference Manual, Data Type (data_type),

Specifying Values (extended_value_spec)