Friday , July 19 2024

How To See Partition Details In Partitioned Table On SQL Server


I explained how to create a partition int the article named “How To Create Partition On SQL Server“.

In this article I will share the script that will show the details of partitions of a partitioned tables.

First, you can see the partitioned tables in the database with the help of the following script.


Then you can see partition details on partitioned tables with the help of the following script.

In the query, you should type the name of the table you want to see the partition detail in the WHERE block, and the name of the database in the USE section.


About dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.


  1. Partition Detail query very helpful thanks!

  2. a good 360 view of partition info for a table. very useful

Leave a Reply

Your email address will not be published. Required fields are marked *