The iiviews Catalog

The iiviews catalog contains one or more entries for each view in the database (views are indicated in iitables by table type = “V”). Because the text_segment column is limited to 240 characters per row, a single view can require more than one row to contain all its text. In this case, the text will be broken in mid-word across the sequenced rows. The text column is pure text, and can contain newline characters.

Column Name	Data Type	Description
table_name	char(256)	The view name. Must be a valid object name.
table_owner	char(32)	The view owner's user name.
view_dml	char(1)	The language in which the view was created: S (for SQL) or Q (for QUEL).
check_option	char(1)	Contains Y if the check option was specified in the create view statement, N if not, or blank if unknown.
text_sequence	integer8	The sequence number for the text field, starting with 1.
text_segment	varchar(240)	The text of the view definition.