C. Standard Catalog Interface : Catalogs : The iiintegrities Catalog
 
Share this page                  
The iiintegrities Catalog
Iiintegrities contains one or more entries for each integrity defined on a table. Because the text of the integrity definition can contain more than 240 characters, iiintegrities may contain more than one row for a single integrity. The text may contain newlines and may be broken mid-word across rows.
Note:  Ingres Star does not support integrities, so there are no rows in this catalog.
This table is keyed on table_name and table_owner:
Column Name
Data Type
Description
table_name
char(256)
The table name. Must be a valid name.
table_owner
char(32)
The table owner. Must be a valid name.
create_date
char(25)
The integrity’s creation date. This is a date field.
integrity_number
smallint
The number of this integrity.
text_sequence
smallint
The sequence number for the text, numbered from 1.
text_segment
varchar (240)
The text of the integrity definition.