DB2 Version 9.7 for Linux, UNIX, and Windows

SYSCAT.VIEWS catalog view

Each row represents a view or materialized query table.

Table 1. SYSCAT.VIEWS Catalog View
Column Name Data Type Nullable Description
VIEWSCHEMA VARCHAR (128)   Schema name of the view or materialized query table.
VIEWNAME VARCHAR (128)   Unqualified name of the view or materialized query table.
OWNER VARCHAR (128)   Authorization ID of the owner of the view or materialized query table.
OWNERTYPE CHAR (1)  
  • S = The owner is the system
  • U = The owner is an individual user
SEQNO SMALLINT Always 1.
VIEWCHECK CHAR (1)   Type of view checking.
  • C = Cascaded check option
  • L = Local check option
  • N = No check option or is a materialized query table
READONLY CHAR (1)  
  • N = View can be updated by users with appropriate authorization or is a materialized query table
  • Y = View is read-only because of its definition
VALID CHAR (1)  
  • N = View or materialized query table definition is invalid
  • X = View or materialized query table definition is inoperative and must be recreated
  • Y = View or materialized query table definition is valid
QUALIFIER VARCHAR (128)   Value of the default schema at the time of object definition. Used to complete any unqualified references.
FUNC_PATH CLOB (2K)   SQL path in effect when the view or materialized query table was defined.
TEXT CLOB (2M)   Full text of the view or materialized query table CREATE statement, exactly as typed.
DEFINER1 VARCHAR (128)   Authorization ID of the owner of the view or materialized query table.
Note:
  1. The DEFINER column is included for backwards compatibility. See OWNER.