describe_stored_proc
Retrieve parameter details for SQL Server stored procedures to understand input requirements and output structure before execution.
Instructions
Get parameter information for a stored procedure.
Args:
procedure: Procedure name, optionally with schema (e.g., 'dbo.sp_GetUser' or 'sp_GetUser')
Returns:
Dictionary with:
- procedure: Full procedure name (schema.name)
- parameters: List of parameter info (name, type, direction, etc.)Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| procedure | Yes |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||