list_stored_procs
Discover and filter stored procedures in SQL Server databases by schema or name pattern to analyze database structure and manage procedures.
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 foundInput Schema
| Name | Required | Description | Default |
|---|---|---|---|
| schema | No | ||
| pattern | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||