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
转载于:https://www.cnblogs.com/qanholas/archive/2011/08/27/2155437.html
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
转载于:https://www.cnblogs.com/qanholas/archive/2011/08/27/2155437.html