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.
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 |