listRoutines
listRoutinesDiscover database function, procedure, and package names in a schema, optionally filtered by a name pattern.
Instructions
Discover function, procedure and package names in a schema, optionally by name pattern. Use getRoutineDefinition when the source of one known routine is needed.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| schema | No | ||
| connection | Yes | Database to run against. Call listConnections for valid names; do not guess. | |
| namePattern | No | JDBC name pattern, e.g. '%calculate%'. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| routines | No | Function, procedure, and package entries. |