如何高效查找SQL Server中与特定关键字相关的存储过程、函数和视图？
- 内容介绍
- 文章标签
- 相关推荐
本文共计72个文字，预计阅读时间需要1分钟。
查询包含关键字的SQL模块及其类型描述：
sqlSELECT name, type_descFROM sys.all_sql_modulesJOIN sys.all_objects o ON s.object_id=o.object_idWHERE definition LIKE '%关键字%'ORDER BY type_desc, name;
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
本文共计72个文字，预计阅读时间需要1分钟。
查询包含关键字的SQL模块及其类型描述：
sqlSELECT name, type_descFROM sys.all_sql_modulesJOIN sys.all_objects o ON s.object_id=o.object_idWHERE definition LIKE '%关键字%'ORDER BY type_desc, name;
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