get_stored_procedure_definition
Retrieve the full SQL definition of a stored procedure from a Microsoft SQL Server database, including schema details and formatted output, enabling efficient code analysis and management.
Instructions
Get the complete SQL query/definition of a stored procedure - this is the actual source code
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| connectionName | No | Named connection to use (e.g., 'production', 'staging') | |
| connectionString | No | SQL Server connection string (uses default if not provided) | |
| formatOutput | No | Format the SQL output for better readability (default: true) | |
| procedureName | Yes | Name of the stored procedure to get definition for | |
| schema | No | Schema name (default: dbo) |