list_tables
Discover database tables and views in SQL Server with optional filtering by schema, name pattern, or view inclusion to analyze database structure.
Instructions
List all tables and views in the database.
Args:
schema: Filter by schema name (e.g., 'dbo'). If not specified, returns all schemas.
include_views: Include views in results (default: True)
pattern: Filter by name pattern using SQL LIKE syntax (e.g., 'Cust%', '%Order%')
Returns:
Dictionary with:
- tables: List of table/view info (schema, name, type)
- count: Number of resultsInput Schema
| Name | Required | Description | Default |
|---|---|---|---|
| schema | No | ||
| include_views | No | ||
| pattern | No |
Output Schema
| Name | Required | Description | Default |
|---|---|---|---|
No arguments | |||