describe_stored_proc
Retrieve parameter information for a SQL Server stored procedure, including name, type, and direction, by specifying the procedure name with optional schema.
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 | |||