sqlserver查找包含关键词的视图

WITH    tab
          AS ( SELECT   a.name ,
                        a.[type] ,
                        b.[definition]
               FROM     sys.all_objects a ,
                        sys.sql_modules b
               WHERE    a.is_ms_shipped = 0
                        AND a.object_id = b.object_id
                        AND a.[type] IN ( 'P', 'V', 'AF' )
             )
    SELECT  *
    FROM    tab
    WHERE   [definition] LIKE '%%'
    ORDER BY tab.name