SELECT o.[name] ,-- o.[type], i.[name], i.[index_id],
f.[name]
FROM sys.indexes i
INNER JOIN sys.filegroups f ON i.data_space_id = f.data_space_id
INNER JOIN sys.all_objects o ON i.[object_id] = o.[object_id]
GO
SQL Server 表所在的文件组
最新推荐文章于 2020-07-25 21:24:47 发布