describe_stored_procedure
Retrieve detailed metadata, parameters, and definitions of a specific stored procedure in Microsoft SQL Server to simplify database analysis and debugging.
Instructions
Get detailed information about a specific stored procedure including parameters and definition
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) | |
includeDefinition | No | Include the procedure definition/body (default: true) | |
procedureName | Yes | Name of the stored procedure to describe | |
schema | No | Schema name (default: dbo) |