SELECT OBJECT_NAME(i.[object_id]) AS [ObjectName]
,i.[index_id] AS [IndexID]
,i.[name] AS [IndexName]
,i.[type_desc] AS [IndexType]
,i.[data_space_id] AS [DatabaseSpaceID]
,f.[name] AS [FileGroup]
,d.[physical_name] AS [DatabaseFileName]
FROM [sys].[indexes] i
INNER JOIN [sys].[filegroups] f
ON f.[data_space_id] = i.[data_space_id]
INNER JOIN [sys].[database_files] d
ON f.[data_space_id] = d.[data_space_id]
INNER JOIN [sys].[data_spaces] s
ON f.[data_space_id] = s.[data_space_id]
WHERE OBJECTPROPERTY(i.[object_id], 'IsUserTable') = 1
ORDER BY OBJECT_NAME(i.[object_id])
,f.[name]
,i.[data_space_id]
查看索引在哪个文件组
最新推荐文章于 2022-04-21 16:07:36 发布