OpenSQL Reference Guide > OpenSQL Reference Guide > OpenSQL Standard Catalogs > Standard Catalog Interface > iiconstraints Catalog
Was this helpful?
iiconstraints Catalog
The iiconstraints catalog contains constraint information.
Column Name
Data Type
Description
constraint_name
char(256)
The name of the constraint.
schema_name
char(32)
The name of the schema.
table_name
char(256)
The name of the table.
constraint_type
char(1)
The type of constraint:
U if Unique
P if Primary
C if Check
R if References
Blank
create_date
char(25)
The date the constraint was created.
text_sequence
integer8
The sequence number, from 1, for the text_segment.
text_segment
varchar(240)
The text of the constraint definition.
system_use
char(1)
U if the object is a user object
G if generated by the system for the user. A status of G is used for constraints or views with check option.
Last modified date: 01/30/2023