Below is the SQL query to get information about the database properties like, its DBname, DBCollation, Recovery model, UserAccess, LogFiles size and DataFile Size.
select m.databasename, a.collation_name,a.RECOVERY_MODEL ,a.user_access_desc,
(Select recovery_model_desc as RECOVERY_MODEL ,collation_name,user_access_desc,database_id
) as a
(Select db_name(database_id) as databasename, database_id,
CAST(SUM(CASE WHEN type_desc = 'LOG' THEN size END) * 8. / 1024 AS DECIMAL(8,2)) as LogFile_MB,
CAST(SUM(CASE WHEN type_desc = 'ROWS' THEN size END) * 8. / 1024 AS DECIMAL(8,2)) as DataFile_MB
from sys.master_files group by database_id) as m on m.database_id= a.database_id