Show TOC

Object documentationVIEWDEFS Locate this document in the navigation structure

 

The system table DOMAIN.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

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)