analyze_table_stats
Retrieve table row counts, size details, and last update statistics for MSSQL databases using a specified connection string or named connection. Optimize database performance and monitoring.
Instructions
Get table row counts, size information, and last update statistics
Input 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 |