The routine_table_usage view provides information about tables used by routines.
| Column name | Data type | Description |
|---|---|---|
specific_catalog |
sql_identifier |
The name of the current database containing the function. |
specific_schema |
sql_identifier |
The name of the schema containing the function. |
specific_name |
sql_identifier |
The “specific name” of the function. |
routine_catalog |
sql_identifier |
The name of the current database containing the function. |
routine_schema |
sql_identifier |
The name of the schema containing the function. |
routine_name |
sql_identifier |
The name of the function. |
table_catalog |
sql_identifier |
The name of the current database containing the table used by the function. |
table_schema |
sql_identifier |
The name of the schema containing the table used by the function. |
table_name |
sql_identifier |
The name of the table used by the function. |