get_stored_procedure_definition
Retrieve the complete SQL source code for a stored procedure in Microsoft SQL Server. View the actual definition to understand database logic or modify procedures.
Instructions
Get the complete SQL query/definition of a stored procedure - this is the actual source code
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') | |
| procedureName | Yes | Name of the stored procedure to get definition for | |
| schema | No | Schema name (default: dbo) | |
| formatOutput | No | Format the SQL output for better readability (default: true) |