(SqlServer)获取视图字段名

Select c.name As ColumnsName , t.name As ColumnsType From SysObjects As o , SysColumns As c , SysTypes As t Where o.type in ('u','v') And o.id = c.id And c.xtype = t.xtype And o.Name = 'View_BMKH'