list_stored_procs
Retrieve a list of stored procedures from a SQL Server database, filterable by schema and name pattern using SQL LIKE syntax.
Instructions
List available stored procedures in the database.
Args:
schema: Filter by schema name (e.g., 'dbo')
pattern: Filter by name pattern using SQL LIKE syntax (e.g., 'sp_%', '%User%')
Returns:
Dictionary with:
- procedures: List of procedure info (schema, name, created, modified)
- count: Number of procedures found
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| schema | No | ||
| pattern | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||