SQL SERVER 查看所有存储过程或视图里 包含某个关键字的查询语句

Posted on | Post modified: | Visitors: 
1
2
3
4
5
6
SELECT name,
       type_desc
FROM   sys.all_sql_modules s
       INNER JOIN sys.all_objects o ON s.object_id = o.object_id
WHERE  definition LIKE '%关键字%'
ORDER BY type_desc, name;
1
2
SELECT name, xtype FROM sysobjects o, syscomments s
WHERE o.id = s.id AND text LIKE '%agent%';
1
2
3
4
5
6
7
8
9
--查询所有包含某列名的对象
SELECT name,
       object_id,
       type,
       type_desc
FROM sys.objects
WHERE object_id IN (
                       SELECT object_id FROM sys.columns WHERE name = 'serverid'
                   );