The system table DOMAIN.TABLES contains all the tables (base tables, view tables, synonyms and results tables) for which the current user has privileges.
SCHEMANAME |
CHAR(32) |
Name of the schema of the table |
OWNER |
CHAR(32) |
Name of the owner of the table |
TABLENAME |
CHAR(32) |
Name of the table |
PRIVILEGES |
CHAR(30) |
Privileges of the current user for the table |
TYPE |
CHAR(8) |
Type of table (SYNONYM | SYSTEM | TABLE) |
TABLETYPE |
CHAR(8) |
Type of table (TABLE | VIEW | SYNONYM | RESULT) |
CREATEDATE |
DATE |
Creation date of the table |
CREATETIME |
TIME |
Creation time of the table |
UPDSTATDATE |
DATE |
Date of the last UPDATE STATISTICS statement executed for the table |
UPDSTATTIME |
TIME |
Time of the last UPDATE STATISTICS statement executed for the table |
ALTERDATE |
DATE |
Change date of the table |
ALTERTIME |
TIME |
Change time of the table |
UNLOADED |
CHAR(3) |
Table is unloaded (YES | NO) |
SAMPLE_PERCENT |
FIXED(3) |
Percentage of table contents to be read for updating statistics |
SAMPLE_ROWS |
FIXED(10) |
Number of rows in table to be read for updating statistics |
COMMENT |
CLOB |
Comment on the table |
TABLEID |
CHAR(8) BYTE |
ID of the table in hexadecimal notation |
DYNAMIC |
CHAR(3) |
Table was defined with DYNAMIC option (YES | NO) |
ARCHIVE |
CHAR(3) |
Table was defined with FOR ARCHIVE option (YES | NO) |
VARIABLE_COLUMNS |
CHAR(3) |
Columns are stored with variable length (YES | NO) |
VIRTUALKEY |
CHAR(3) |
Table was defined with the CLUSTER option (YES | NO) |
If the TABLES system table is called by the database system administrator, information from all database users’ tables is displayed.