33.7. 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 33-5. 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 33.33 for more information.

Back to top

(С) Виктор Вислобоков, 2008-2010