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.
