Chapter 10: Partitioning Tables and Indexes

Displaying information about partitions

Use sp_helpartition to view information about partitions. For example, to view information about the p1 partition in publishers, enter:

sp_helpartition publishers, null, p1

See the Reference Manual for complete syntax and usage information for sp_helpartition.