search_sql_definitions
Search for SQL object IDs containing a specific term to discover references to tables, fields, or identifiers in the PeopleSoft database.
Instructions
Search for SQL object IDs whose text contains the given term.
Useful for discovering which SQL objects reference a table, field, or
other identifier. Does not return full SQL text—use get_sql_definition
for that.
Args:
search_term: Text to search for in SQL (e.g. 'PS_JOB', 'ABSV_REQUEST')
limit: Maximum number of SQLIDs to return (default 50)
Returns:
List of matching SQLIDs with sql_type and market.
Example:
search_sql_definitions("PS_ABSV_REQUEST")
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| limit | No | ||
| search_term | Yes |