SQL Query to get logfile size, datafile size, recovery model, collations

Below is the SQL query to get information about the database properties like, its DBname, DBCollation, Recovery model, UserAccess, LogFiles size and DataFile Size.

 

Database Information
Database Information