There are several functions you can use to display partition information.
data_pages – returns the number of pages used by a table, index, or partition.
reserved_pages – returns the number of pages reserved for a table, index, or partition.
row_count – estimates the number of rows in a table or partition.
used_pages – returns the number of pages used by a table, index, or partition. Unlike data_pages, used_pages includes pages used by internal structures.
partition_id – returns the partition ID of a specified partition for specified index.
partition_name – returns the partition name that corresponds to the specified index and partition IDs.
data_pages(5, 31000114)
select partition_id(“testtable”, testtable_ptn1”)
select partition_name(0, 1111111111)