The system table TABLES contains all the tables (base tables, view tables, synonyms, and event tables) for which the current user has privileges.
TABLES
OWNER |
CHAR(32) |
Name of table owner |
TABLENAME |
CHAR(32) |
Name of the table |
PRIVILEGES |
CHAR(30) |
Privileges of current user for the table |
TYPE |
CHAR(8) |
Type of table (SYSTEMS | TABLES) |
TABLETYPE |
CHAR(8) |
Table type (TABLE | VIEW | SYNONYM | RESULT) |
CREATEDATE |
DATE(10) |
Creation date of the table |
CREATETIME |
TIME(8) |
Creation time of the table |
UPDSTATDATE |
DATE(10) |
Date of the last UPDATE STATISTICS statement for the table |
UPDSTATTIME |
TIME(8) |
Time of the last UPDATE STATISTICS statement for the table |
ALTERDATE |
DATE(10) |
Change date of the table |
ALTERTIME |
TIME(8) |
Change time of the table |
UNLOADED |
CHAR(3) |
Table is unloaded (YES | NO) |
SAMPLE_PERCENT |
FIXED(3) |
Percentage of the table that is updated when updating statistics |
SAMPLE_ROWS |
FIXED(10) |
Number of rows in the table that are updated when updating statistics |
COMMENT |
LONG |
Comment about the table |
TABLEID |
CHAR(8) BYTE |
Table ID in hexadecimal format |
See also:
Evaluating System Tables ® TABLES