Determine table partition key with partition number RRS feed

  • Question

  • Hi,

    How can we identify the partition key once the table partitions are created ??
    the query below gives the partition number(eg. 1) to which the partition key(eg. 100) belongs to
    SELECT $PARTITION.PartitionRange (partition key). 
    Similarly, how can we identify the partition key for a particular partition number. Like, if the partition number is 1, I need to know the partition key (or if possible the partition range) of that partition.



    Friday, December 4, 2009 6:08 AM