@淮里路小佩奇 第二:如果成立,会有相同的id号码。类似于下面语句中的object_id。 这知识点好像没啥用。。。忘光了快
SELECT OBJECT_NAME(i.object_id) as 表名, data_pages as 数据页数,*
from sys.indexes as i
Join sys.partitions as p on p.object_id = i.object_id and p.index_id= i.index_id
join sys.allocation_units as a on a.container_id = p.partition_id
where i.object_id = OBJECT_ID('tableA')