36.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 36.6. check_constraint_routine_usage Columns

NameData TypeDescription
constraint_catalogsql_identifierName of the database containing the constraint (always the current database)
constraint_schemasql_identifierName of the schema containing the constraint
constraint_namesql_identifierName of the constraint
specific_catalogsql_identifierName of the database containing the function (always the current database)
specific_schemasql_identifierName of the schema containing the function
specific_namesql_identifier The specific name of the function. See Section 36.40 for more information.