TABLES
The system table DOMAIN.TABLES contains information from 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 |
Identification 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) |
|
CLUSTERCOSTSAVINGPERCENTAGE |
FIXED(3) |
Percentage of I/O savings because of CLUSTER option |
|
DATASOURCEID |
CHAR(8) |
datasource identification for the external table |
If the TABLES system table is called by the database system administrator, information from all database users' tables is displayed.
Evaluating System Tables, TABLES
SQL Reference Manual, Table Name (table_name)