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
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