select DB_NAME(smf.database_id)DatabaseName,type_desc,smf.name,physical_name,size ,sd.collation_name
from sys.master_files smf
inner join sys.databases sd
on db_name(smf.database_id) = sd.name
where db_name(smf.database_id)
 not in ('master','model','tempdb','msdb')
order by name