27,579
社区成员
发帖
与我相关
我的任务
分享
select t.name as '表名',
i.type_desc as '索引类型',
case when is_primary_key = 1 then '主键'
else '非主键'
end as '键',
ds.name as '分区方案名称',
ds.type_desc '对象类型',
case when ds.is_default = 1 then '默认文件组'
else '非默认文件组'
end as '是否默认文件组',
pf.name '分区函数',
pf.type_desc '分区函数类型',
pf.fanout '函数创建的分区数',
case when pf.boundary_value_on_right =1
then '边界值包含在边界的right区域'
when pf.boundary_value_on_right = 0
then '边界值包含在边界值的left区域'
end as '边界说明',
prv.boundary_id as '边界id',
tp.name AS '边界值的数据类型',
prv.value '边界值'
from sys.tables t
inner join sys.indexes i
on i.object_id = t.object_id
inner join sys.data_spaces ds
on ds.data_space_id = i.data_space_id
inner join sys.partition_schemes ps
on ds.data_space_id = ps.data_space_id
inner join sys.partition_functions pf
on pf.function_id = ps.function_id
inner join sys.partition_range_values prv
on prv.function_id = pf.function_id
inner join sys.partition_parameters pp
on pp.function_id = prv.function_id
and pp.parameter_id = prv.parameter_id
inner join sys.types tp
on tp.system_type_id = pp.system_type_id
and tp.user_type_id = pp.user_type_id
where 1=1
--i.object_id = 213575799 and
--i.index_id = 1