list_stored_procedures
Retrieve and list all stored procedures and functions in an MSSQL database, including schema details and optional system objects, using a SQL Server connection string or named connection.
Instructions
List all stored procedures, functions, and their basic information
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) | |
includeSystemObjects | No | Include system stored procedures (default: false) | |
schema | No | Schema name (default: dbo) |