TABLES
This
system table contains all the tables (base tables, views, synonyms, result tables) for which the current user has privileges.TABLES
|
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 (TABLE | VIEW | SYNONYM | RESULT) |
|
CREATEDATE |
DATE |
Creation date of the table |
|
CREATETIME |
TIME |
Creation time of the table |
|
UPDSTATDATE |
DATE |
Date at which the UPDATE STATISTICS statement was last carried out on the table |
|
UPDSTATTIME |
TIME |
Time at which the UPDATE STATISTICS statement was last carried out on 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 share of the table to be used to update statistics |
|
SAMPLE_ROWS |
FIXED(10) |
Number of lines in the table to be used to update statistics |
|
COMMENT |
LONG |
Comment on the table |
|
TABLEID |
CHAR(8) BYTE |
Table identification in hexadecimal notation |