Find Current Location of Data and Log File of All the Database using sql command

The sql command to list the current data and log file locaiton is as follows.

select name, physical_name As current_file_locaton from sys.master_files


Following is the output of files used by my SQL Server instance.