search_stored_procedures_by_content
Find stored procedures containing specific text or patterns in their SQL code to locate database logic and dependencies.
Instructions
Search for stored procedures containing specific text or patterns in their SQL definition
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| connectionString | No | SQL Server connection string (uses default if not provided) | |
| connectionName | No | Named connection to use (e.g., 'production', 'staging') | |
| searchText | Yes | Text or pattern to search for in procedure definitions | |
| schema | No | Schema name (default: dbo) | |
| caseSensitive | No | Case sensitive search (default: false) | |
| includeDefinitions | No | Include full procedure definitions in results (default: false) |