or simply:

SELECT * FROM master.sys.master_files

if you want that matched up to the database name

select c.name,a.name as logicalname,a.physical_name from

master.sys.master_files a

inner join master.sys.sysdatabases c on a.database_id=c.dbid

order by dbid