VIEWDEFS 
Definition
The system table VIEWDEFS contains the definitions of the view tables for which the current user has privileges.
Structure
VIEWDEFS
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 |
LEN |
FIXED(5) |
Length of the view table definition |
DEFINITION |
LONG |
SQL statement text in the view table definition |
See also:
Evaluating System Tables, VIEWDEFS
VIEWCOLUMNS, VIEWS, VIEWTABLES
SQL Reference Manual, CREATE VIEW Statement (create_view_statement)