Execute this code

select d.name,mf.name,mf.physical_name

from sys.databases d

inner join sys.master_files mf on mf.database_id=d.database_id