怎样获取SQL Server 视图中的内容(视图定义)

select b.definition from
sysobjects a left join sys.sql_modules b on a.id=b.object_id
where a.xtype='V' and a.Name='视图名称'