Use
This table contains all the view tables for which the current user has privileges.
Structure
VIEWS
OWNER |
CHAR(32) |
Name of the owner of the view table |
VIEWNAME |
CHAR(32) |
Name of the view table |
PRIVILEGES |
CHAR(30) |
Privileges of the user for the view table |
TYPE |
CHAR(8) |
Type of table |
CREATEDATE |
DATE |
Creation date of the view table |
CREATETIME |
TIME |
Creation time of the view table |
UPDSTATDATE |
DATE |
Date at which the UPDATE STATISTICS statement was last carried out on the view table |
UPDSTATTIME |
TIME |
Time at which the UPDATE STATISTICS statement was last carried out on the view table |
ALTERDATE |
DATE |
Alter date of the view table |
ALTERTIME |
TIME |
Alter time of the view table |
UNLOADED |
CHAR(3) |
View table is unloaded (YES | NO) |
COMMENT |
LONG |
Comment on the view table |
Integration
System tables