complete information about all database files in SQL Server

select * from sys.master_files