get_table_stats
Retrieve SQL Server table statistics including row count, total size, index size, and fragmentation. Provide table name and optional schema, database, or server to get these metrics.
Instructions
Get table statistics: row count, total size, index size, and fragmentation
Tool call template
Replace each placeholder with a value matching the input schema. Only required parameters are included; add optional parameters as needed.
{
"id": 1,
"jsonrpc": "2.0",
"method": "tools/call",
"params": {
"arguments": {
"table": "<table>"
},
"name": "get_table_stats"
}
}Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| table | Yes | Table name | |
| schema | No | Schema name (default: dbo) | |
| database | No | Database name (uses connection default if omitted) | |
| server | No | Target server name (uses default if omitted) |