How can we obtain all the current databases?

To list the databases available in your SQL Server and show the path of
the .MDF data files:

SELECT [name] [Database], [filename] [File Path]
FROM master..sysdatabases