Quick thought, sys.partitions is probably the best option as it does not require dynamic sql or depreciated backward compatibility objects.

😎