USE YourDatabase
GO
 
SELECT 
    db.name AS DatabaseName,
    mf.name AS FileName,
    mf.size AS FileSizeMB,
    mf.growth AS FileGrowthMB
FROM 
    sys.databases db
JOIN 
    sys.master_files mf ON db.database_id = mf.database_id
	WHERE db.name LIKE '**%'  AND db.name  NOT LIKE  '%**%'  AND mf.name NOT LIKE '%log'
ORDER BY 
    db.name, 
    mf.name;
------------------------------------另一种显示--------------------------------------------

SELECT 
 (Cast(mf.name  as varchar(20)) +'('+ Cast(mf.size as varchar(20))+')')  
FROM 
    sys.databases db
JOIN 
    sys.master_files mf ON db.database_id = mf.database_id
	WHERE db.name LIKE '**%'  AND db.name  NOT LIKE  '%**%'  AND mf.name NOT LIKE '%log'
ORDER BY 
    db.name, 
    mf.name;