A. System Catalogs : Standard Catalog Interface : Standard Catalogs for All Databases : iiconstraints Catalog
 
Share this page                  
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.