---
title: "`view_routine_usage`"
id: infoschema-view-routine-usage
pg_version: "20devel"
---

<a id="infoschema-view-routine-usage"></a>

## 35.74. `view_routine_usage`

The view `view_routine_usage` identifies all routines (functions and procedures) that are used in the query expression of a view (the `SELECT` statement that defines the view). A routine is only included if that routine is owned by a currently enabled role. 

**view_routine_usage Columns**

| Column Type | Description | 
| --- | --- |
| `table_catalog` `sql_identifier` | Name of the database containing the view (always the current database) |
| `table_schema` `sql_identifier` | Name of the schema containing the view |
| `table_name` `sql_identifier` | Name of the view |
| `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 35.55](infoschema-routines.md) for more information. |