SELECT name, database_id, create_date, compatibility_level,collation_name, is_auto_shrink_on, state_desc, recovery_model_desc FROM sys.databases