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
sqlserver查找包含关键词的视图
最新推荐文章于 2024-03-15 13:40:08 发布