36.8. check_constraint_routine_usage

36.8. `check_constraint_routine_usage`
Prev	Up	Chapter 36. The Information Schema	Home	Next

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 36.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 36.41 for more information.

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 36.41 for more information.

Prev	Up	Next
36.7. `character_sets`	Home	36.9. `check_constraints`