get_procedure_schema
Retrieve the schema and parameter details for a specific stored procedure in SQL Server to understand its structure and required inputs.
Instructions
Gets the schema and parameters of a specific stored procedure
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| procedureName | Yes | Name of the stored procedure | |
| schemaName | No | Schema name (default: dbo) | dbo |
Input Schema (JSON Schema)
{
"properties": {
"procedureName": {
"description": "Name of the stored procedure",
"type": "string"
},
"schemaName": {
"default": "dbo",
"description": "Schema name (default: dbo)",
"type": "string"
}
},
"required": [
"procedureName"
],
"type": "object"
}