C. Standard Catalog Interface : Catalogs : The iiviews Catalog
 
Share this page                  
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 256 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 text and may contain newline characters.
Column Name
Data Type
Description
table_name
char(256)
The view name. Must be a valid Ingres name.
table_owner
char(32)
The view owner’s Ingres username.
view_dml
char(8)
The language in which the view was created: S (for SQL).
check_option
char(8)
Y if the check option was specified in the create view statement, or N if not. Set to blank if unknown.
text_sequence
integer
The sequence number for the text field, starting with 1.
text_segment
varchar(256)
The text of the view definition.