SQL Reference

SYSCAT.VIEWS

Contains one or more rows for each view that is created.

Table 100. SYSCAT.VIEWS Catalog View

Column Name	Data Type	Nullable	Description
VIEWSCHEMA	VARCHAR(128)		Name of the view or the name of a table used to define a summary table.
VIEWNAME	VARCHAR(128)
DEFINER	VARCHAR(128)		Authorization ID of the creator of the view.
SEQNO	SMALLINT		Always 1.
VIEWCHECK	CHAR(1)		States the type of view checking: N = No check option L = Local check option C = Cascaded check option
READONLY	CHAR(1)		Y = View is read-only because of its definition. N = View is not read-only.
VALID	CHAR(1)		Y = View or summary table definition is valid. X = View or summary table definition is inoperative; must be re-created.
QUALIFIER	VARCHAR(128)		Contains value of the default schema at the time of object definition.
FUNC_PATH	VARCHAR(254)		The SQL path of the view creator at the time the view was defined. When the view is used in data manipulation statements, this path must be used to resolve function calls in the view. SYSIBM for views created before Version 2.
TEXT	CLOB(64k)		Text of the CREATE VIEW statement.