How can I tell what recovery model my SQL database has?

Is there a SQL command I can run to determine the recovery model of my database? I want to know if its full recovery or not.

Some variety in how to do it...

SELECT D.recovery_model_desc FROM sys.databases D WHERE name = 'MyDB'

or

SELECT name, D.recovery_model_desc FROM sys.databases D

or

SELECT DATABASEPROPERTYEX('MyDB', 'Recovery')

StackExchange Database Administrators Q#1485, answer score: 23