Select physical_name From Sys.database_files

C:Program FilesMicrosoft SQL ServerMSSQL12.MSSQLSERVERMSSQLDATAmaster.mdf
C:Program FilesMSSQLDATAmuser.mdf

o/p

Col1                                                                   col2

C:Program FilesMicrosoft SQL ServerMSSQL12.MSSQLSERVERMSSQLDATA   master.mdf

C:Program FilesMSSQLDATA                                      muser.mdf