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)