VIEWDEFS
The system table DOMAIN.VIEWDEFS
contains
the definitions of the view tables for which the current user has privileges.
Structure
|
CHAR(32) |
Name of the schema of the view table |
|
CHAR(32) |
Name of the owner of the view table |
|
CHAR(32) |
Name of the view table |
|
FIXED(5) |
Length of the view table definition |
|
CLOB |
SQL statement text in the view table definition |
More Information
VIEWCOLUMNS, VIEWS, VIEWTABLES
Evaluating System Tables, VIEWDEFS
SQL Reference Manual, CREATE VIEW Statement (create_view_statement)