SYSVIEWS

Describes the view definitions within the current database.

Column Name	Type	Length	Nullability	Contents
TABLEID	CHAR	36	false	unique identifier for the view (called TABLEID since it is joined with column of that name in SYSTABLES)
VIEWDEFINITION	LONG VARCHAR		false	text of view definition
CHECKOPTION	CHAR	1	false	'N' (check option not supported yet)
COMPILATION SCHEMAID	CHAR	36	false	id of the schema containing the view

---

Previous Page
Next Page
Table of Contents
Index