searchObjects
searchObjectsFind database objects by full or partial name. Searches non-system tables, views, routines, packages, sequences, and synonyms case-insensitively to help you locate objects.
Instructions
Find database objects when only a full or partial name is known. Searches non-system tables, views, routines, packages, sequences and synonyms case-insensitively; use describeTable after finding a table or view whose structure is needed.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| connection | Yes | Database to run against. Call listConnections for valid names; do not guess. | |
| namePattern | Yes | Name pattern — plain substring (auto-wrapped in %..%) or explicit pattern with % / _ |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| objects | No | Matching database objects across tables, views, routines, sequences, and synonyms. |