Search Stored Procedures by Content
search_stored_procedures_by_contentFind stored procedures by searching for specific text or patterns in their SQL definitions. Supports case-sensitive search and schema filtering.
Instructions
Search for stored procedures containing specific text or patterns in their SQL definition
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| schema | No | Schema name (default: dbo) | |
| searchText | Yes | Text or pattern to search for in procedure definitions | |
| caseSensitive | No | Case sensitive search (default: false) | |
| connectionName | No | Named connection to use (e.g., 'production', 'staging') | |
| includeDefinitions | No | Include full procedure definitions in results (default: false) |