analyze_table_stats
Retrieve row counts, table sizes, and last update statistics from SQL Server databases using a connection string or named connection. Supports schema and table filters for targeted analysis.
Instructions
Get table row counts, size information, and last update statistics
Input Schema
TableJSON 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) | |
| schema | No | Schema name (default: dbo) | |
| tableName | No | Filter by specific table name |