How to check Recovery mode all SQL Server databases

 How to check Recovery mode all SQL Server databases

select [name], DATABASEPROPERTYEX([name],'recovery')

from sysdatabases

where name not in ('master','model','tempdb','msdb')