describe_stored_procedure
Retrieve detailed information about a stored procedure in Microsoft SQL Server, including parameters and procedure definition, using the connection string or named connection.
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) |