获得分区表信息

select distinct
ps.Name AS PartitionScheme,o.name as TableName
 from sys.partitions p
join sys.indexes   as i on p.object_id = i.object_id AND p.index_id = i.index_id
join sys.partition_schemes  as ps   ON i.data_space_id=ps.data_space_id
join sys.objects as o ON o.object_id = i.object_id