search_schema
Find tables and columns by name substring across all non-system schemas to locate the field you need when you don't know which table contains it.
Instructions
Find tables and columns whose name contains a substring, across every non-system schema. Use it when you know the field you need but not which table holds it. Note that "_" and "%" are wildcards.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| schema | No | Restrict the search to one schema. | |
| pattern | Yes | Substring to look for in table and column names. | |
| connection_id | Yes | Connection id. See list_connections. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| result | Yes |