The routine_sequence_usage view provides information about sequences 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. |
schema_catalog |
sql_identifier |
The name of the current database containing the sequence used by the function. |
sequence_schema |
sql_identifier |
The name of the schema containing the sequence used by the function. |
sequence_name |
sql_identifier |
The name of the sequence used by the function. |