602SQL Documentation Index  


The system query _iv_check_constrains returns a list of internal integrity constraints defined on database tables.

The result of this query may be very complex. It is recommended to use this only inside of another query that specifies the desired constraints for the column values.

Column description

Column name Type Contents
Schema_name CHAR(31) Name of the schema the table belongs
Table_name CHAR(31) Name of the table
Constrain_name CHAR(31) Name of the integrity constraint
Definition CLOB Condition (logic expression)
Deferred SMALLINT Deferred execution on transaction end (0=not deferred, 1=deferred, NULL=not specified)