Search Tables
search_tablesFind tables by name or description across IBM DB2 for i libraries using * wildcards. Optionally include system libraries or restrict to a schema allowlist.
Instructions
Find tables by name or description text across libraries. Matches TABLE_NAME, SYSTEM_TABLE_NAME, and TABLE_TEXT. Use * as a wildcard. When a schema allowlist is configured, only those libraries are searched. Otherwise system libraries (Q* and SYS*) are skipped unless include_system is true.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | Maximum rows to return. Capped by QUERY_MAX_LIMIT. | |
| filter | Yes | Name or text to match. Use * as a wildcard. Example: "ORDER*" matches tables starting with ORDER | |
| schema | No | Limit the search to one library. Must be in the schema allowlist when one is configured. | |
| include_system | No | Include Q* and SYS* libraries. Ignored when a schema or a schema allowlist is set. |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
| data | No | ||
| count | No | ||
| error | No | ||
| success | Yes | ||
| truncated | No |