39.8. `check_constraint_routine_usage`
Prev | Up | Chapter 39. The Information Schema | Home | Next

## 39.8. `check_constraint_routine_usage` #

The view `check_constraint_routine_usage` identifies routines (functions and procedures) that are used by a check constraint. Only those routines are shown that are owned by a currently enabled role.

Table 39.6. `check_constraint_routine_usage` Columns

Column Type Description
`constraint_catalog` `sql_identifier` Name of the database containing the constraint (always the current database)
`constraint_schema` `sql_identifier` Name of the schema containing the constraint
`constraint_name` `sql_identifier` Name of the constraint
`specific_catalog` `sql_identifier` Name of the database containing the function (always the current database)
`specific_schema` `sql_identifier` Name of the schema containing the function
`specific_name` `sql_identifier` The “specific name” of the function. See Section 39.45 for more information.

Prev | Up | Next
39.7. `character_sets` | Home | 39.9. `check_constraints`