The syscheckudrdep system catalog table describes each check constraint that is referenced by a user-defined routine (UDR) in the database. The syscheckudrdep table has the following columns.
| Column | Type | Explanation | |
|---|---|---|---|
| udr_id | INTEGER | Unique code identifying the UDR | |
| constraint_id | INTEGER | Unique code identifying the check constraint | |
Each check constraint described in the syscheckudrdep table also has its own row in the sysconstraints system catalog table, where the constrid column has the same value as the constraint_id column of syscheckudrdep.
A composite index on the udr_id and constraint_id columns requires that combinations of these values be unique.
Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]