Location of Data Files in SQL Server

You may get the physical location of MDF and LDF files by using following query.

select name,physical_name from sys.master_files

You may see other properties of databases i.e. size, maximum size, growth etc by using "select *" on sys.master_files.