sqlserver查找包含关键词的视图

发布时间：2020-12-12 13:05:59 所属栏目：MsSql教程来源：网络整理

导读：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

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

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!