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')