 |
|
|
 | _IV_INDICIES System Query |  | System Queries | _IV_FOREIGN_KEYS System Query |  |
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 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) |
| _IV_INDICIES System Query | | System Queries | _IV_FOREIGN_KEYS System Query | |