SQL Server 查看文件及文件組的語句:
具體示例如下
SELECT df[name] dfphysical_name df[size] dfgrowth f[name] [filegroup] fis_default FROM sysdatabase_files df JOIN sysfilegroups f ON dfdata_space_id = fdata_space_id