SQL Server ->> 查找哪些表/索引用了文件组

SELECT t.object_id AS ObjectID,
       OBJECT_NAME(t.object_id) AS ObjectName,
       SUM(u.total_pages) * 8 AS Total_Reserved_kb,
       SUM(u.used_pages) * 8 AS Used_Space_kb,
       u.type_desc AS TypeDesc,
       MAX(p.rows) AS RowsCount,
       fg.name
FROM sys.allocation_units AS u
JOIN sys.partitions AS p ON u.container_id = p.hobt_id
JOIN sys.tables AS t ON p.object_id = t.object_id
JOIN sys.filegroups AS fg ON fg.data_space_id = u.data_space_id
WHERE fg.name IN (‘‘)
GROUP BY t.object_id,
         OBJECT_NAME(t.object_id),
         u.type_desc,
       fg.name
ORDER BY Used_Space_kb DESC,
         ObjectName;