--1. 查看DB中有多少个文件组
SELECT * FROM sys.filegroups
--2. 查看文件相关联的文件组
SELECT df.[name],
df.physical_name,
df.[size],
df.growth,
f.[name] [filegroup],
f.is_default
FROM sys.database_files df
JOIN sys.filegroups f
ON df.data_space_id = f.data_space_id
--3. 查看某个表属于哪个文件组
----3.1. 在众多结果中找到 [ Data_located_on_filegroup ]
sp_help 'tableName'
----3.2
SELECT o.[name],
o.[type],
i.[name],
i.[index_id],
f.[name] AS [filegroup_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]
WHERE o.[TYPE]='U'
AND o.name IN ('tableName')
查看文件组相关
最新推荐文章于 2022-12-16 20:38:10 发布