VIEWTABLES 
Definition
The system table VIEWTABLES contains the names of the underlying tables for all view tables for which the current user has privileges.
Structure
VIEWTABLES
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 |
TABLESCHEMANAME |
CHAR(32) |
Name of the schema of the table |
TABLENAME |
CHAR(32) |
Name of the table |
See also:
SQL Reference Manual, CREATE VIEW Statement (create_view_statement)