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.
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"connection": "<connection>",
"namePattern": "<namePattern>"
},
"name": "searchObjects"
}
}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. |