• SELECT

    p.[object_id],

    p.[index_id],

    pc.[partition_column_id],

    pc.[modified_count]

    FROM sys.system_internals_partition_columns pc

    JOIN sys.partitions p

    ON pc.[partition_id] = p.[partition_id]

    WHERE p.[object_id] = OBJECT_ID ('Yourtablename');