¿Cómo obtener la desripción de una vista en SQL Server?

Ejemplo

use msdb

GO

select OBJECT_DEFINITION(OBJECT_id('sysmail_event_log')) 

AS [processing-instruction(x)] FOR XML PATH('')

GO

Resultado

<?x 

CREATE VIEW sysmail_event_log

AS

SELECT log_id,

       CASE event_type 

          WHEN 0 THEN 'success' 

          WHEN 1 THEN 'information' 

          WHEN 2 THEN 'warning' 

          ELSE 'error' 

       END as event_type,

       log_date,

       description,

       process_id,

       sl.mailitem_id,

       account_id,

       sl.last_mod_date,

       sl.last_mod_user

FROM [dbo].[sysmail_log]  sl

WHERE (ISNULL(IS_SRVROLEMEMBER(N'sysadmin'), 0) = 1) OR 

      (EXISTS ( SELECT mailitem_id FROM [dbo].[sysmail_allitems] ai WHERE sl.mailitem_id = ai.mailitem_id ))

?>