# 37.63. view\_column\_usage

The view `view_column_usage` identifies all columns that are used in the query expression of a view (the `SELECT` statement that defines the view). A column is only included if the table that contains the column is owned by a currently enabled role.

#### Note

Columns of system tables are not included. This should be fixed sometime.

#### **Table 37.61. `view_column_usage` Columns**

| <p>Column Type</p><p>Description</p>                                                                                                                                                               |
| -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| <p><code>view\_catalog</code> <code>sql\_identifier</code></p><p>Name of the database that contains the view (always the current database)</p>                                                     |
| <p><code>view\_schema</code> <code>sql\_identifier</code></p><p>Name of the schema that contains the view</p>                                                                                      |
| <p><code>view\_name</code> <code>sql\_identifier</code></p><p>Name of the view</p>                                                                                                                 |
| <p><code>table\_catalog</code> <code>sql\_identifier</code></p><p>Name of the database that contains the table that contains the column that is used by the view (always the current database)</p> |
| <p><code>table\_schema</code> <code>sql\_identifier</code></p><p>Name of the schema that contains the table that contains the column that is used by the view</p>                                  |
| <p><code>table\_name</code> <code>sql\_identifier</code></p><p>Name of the table that contains the column that is used by the view</p>                                                             |
| <p><code>column\_name</code> <code>sql\_identifier</code></p><p>Name of the column that is used by the view</p>                                                                                    |