| title | description | ms.reviewer | ms.topic | ms.date |
|---|---|---|---|---|
.show database extents partitioning statistics command |
Learn how to use the `.show database extents partitioning statistics` command to display the database's partitioning statistics. |
vplauzon |
reference |
08/17/2023 |
Displays statistics of data partitioning for all tables in the database that have a data partitioning policy defined.
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.
.show database DatabaseName extents partitioning statistics
| Name | Type | Required | Description |
|---|---|---|---|
| DatabaseName | string |
✔️ | The name of the database for which to show the partitioning statistics. |
| 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.