The system table DOMAIN.VIEWS contains all the view tables for which the current user has privileges.
SCHEMANAME |
CHAR(32) |
Name of the schema of the view table |
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 of the last UPDATE STATISTICS statement executed for the view table |
UPDSTATTIME |
TIME |
Time of the last UPDATE STATISTICS statement executed for the view table |
ALTERDATE |
DATE |
Date on which the view table was changed |
ALTERTIME |
TIME |
Time at which the view table was changed |
UNLOADED |
CHAR(3) |
View table is unloaded (YES | NO) |
WITHCHECKOPTION |
CHAR(3) |
Indicates whether the view table was created WITH CHECK OPTION or not (YES | NO) |
COMPLEX |
CHAR(3) |
Indicates whether the view table is a complex view table or not (YES | NO) |
COMMENT |
CLOB |
Comment on the view table |
VIEWDEFS, VIEWCOLUMNS, VIEWTABLES
Evaluating System Tables, VIEWS
SQL Reference Manual, CREATE VIEW Statement (create_view_statement)