list_programmable_objects
Retrieve stored procedures, functions, views, and triggers from a SQL Server database with schema details and timestamps. Filter by object types and schemas to explore database structure.
Instructions
List stored procedures, functions, views, and triggers in a database. Returns JSON with schema, name, type, and create/modify dates.
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| serverName | Yes | Server name from list_servers | |
| databaseName | Yes | Database name from list_databases | |
| includeSchemas | No | Optional comma-separated schemas to include (e.g. 'dbo,sales'). Overrides excludeSchemas. | |
| excludeSchemas | No | Optional comma-separated schemas to exclude (e.g. 'sys,INFORMATION_SCHEMA'). Ignored if includeSchemas set. | |
| objectTypes | No | Optional comma-separated object types to filter: PROCEDURE, FUNCTION, VIEW, TRIGGER |