Object documentationCOLUMNS Locate this document in the navigation structure

 

The system table DOMAIN.COLUMNS contains the columns of all the tables, view tables, results tables, and synonyms for which the current user has privileges.

Structure

COLUMNS

SCHEMANAME

CHAR(32)

Name of the schema of the database object

OWNER

CHAR(32)

Name of the owner of the database object

TABLENAME

CHAR(32)

Name of the database object

COLUMNNAME

CHAR(32)

Name of the column

MODE

CHAR(3)

Type of column (KEY | MAN | OPT)

DATATYPE

CHAR(10)

Data type of column (BOOLEAN | CHAR | DATE | FIXED | FLOAT | INTEGER | CLOB | BLOB | SMALLINT | TIME | TIMESTAMP)

CODETYPE

CHAR(8)

Code attribute of column (ASCII | BYTE | UNICODE)

LEN

FIXED(4)

Length or precision of the column

DEC

FIXED(3)

Number of decimal places in the columns of data type FIXED

NULLABLE

CHAR(3)

Column can accept NULL value (YES | NO)

COLUMNPRIVILEGES

CHAR(8)

Privileges of the current user for the column

DEFAULT

CHAR(254)

DEFAULT value for the column

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

DOMAINOWNER

CHAR(32)

Name of the domain owner used for column definition

DOMAINNAME

CHAR(32)

Name of the domain used for column definition

POS

FIXED(4)

Original position of the column in the table

KEYPOS

FIXED(4)

Original position of the key column in the table

PHYSICALPOS

FIXED(4)

Position of column on disk

CREATEDATE

DATE

Creation date of the column

CREATETIME

TIME

Creation time of the column

ALTERDATE

DATE

Alter date of the column

ALTERTIME

TIME

Alter time of the column

TABLETYPE

CHAR(8)

Type of table (TABLE | VIEW | SYNONYM | RESULT | SYSTEM)

COMMENT

CLOB

Comment on the column

More Information

Evaluating System Tables, COLUMNS

SQL Reference Manual, Data Type (data_type)