Display Data and Log File Paths for Microsoft SQL Server Instance

Find all the data and log file paths for all databases on Microsoft SQL Server instance.

SELECT name, physical_name AS current_file_location FROM sys.master_files