# 37.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 37.6. `check_constraint_routine_usage` Columns**

| <p>Column Type</p><p>Description</p>                                                                                                                                                                                              |
| --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| <p><code>constraint\_catalog</code> <code>sql\_identifier</code></p><p>Name of the database containing the constraint (always the current database)</p>                                                                           |
| <p><code>constraint\_schema</code> <code>sql\_identifier</code></p><p>Name of the schema containing the constraint</p>                                                                                                            |
| <p><code>constraint\_name</code> <code>sql\_identifier</code></p><p>Name of the constraint</p>                                                                                                                                    |
| <p><code>specific\_catalog</code> <code>sql\_identifier</code></p><p>Name of the database containing the function (always the current database)</p>                                                                               |
| <p><code>specific\_schema</code> <code>sql\_identifier</code></p><p>Name of the schema containing the function</p>                                                                                                                |
| <p><code>specific\_name</code> <code>sql\_identifier</code></p><p>The “specific name” of the function. See <a href="https://www.postgresql.org/docs/current/infoschema-routines.html">Section 37.45</a> for more information.</p> |