Display 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: Procedures.