.show database extents partitioning statistics
Displays statistics of data partitioning for all tables in the database that have a data partitioning policy defined.
Permissions
You must have at least Database User, Database Viewer, or Database Monitor permissions to run this command. For more information, see role-based access control.
Syntax
.show database DatabaseName extents partitioning statistics
Parameters
| Name | Type | Required | Description |
|---|---|---|---|
| DatabaseName | string |
✔️ | The name of the database for which to show the partitioning statistics. |
Returns
| Column name | Column type | Description |
|---|---|---|
| TableName | string |
The name of the table |
| PartitioningPolicy | dynamic |
JSON representation of the policy |
| TotalRowCount | long |
Total number of rows in the table* |
| PartitionedRowCount | long |
Number of partitioned rows in the table* |
| PartitionedRowPercentage | real |
Percentage of partitioned rows from all rows in the table* |
* Values may be up to 15 minutes old, as they're taken from a cached summary of the table's extents.
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for