SQL Server Data Files

The following statement returns the database files for the databases on the server.

SELECT name,filename
FROM master.dbo.sysdatabases