欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  数据库

关键字查找相关的存储过程、触发器、函数和视图

程序员文章站 2022-04-30 09:22:10
...

关键字查找相关的存储过程、触发器、函数和视图 无 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 '%keyword%' 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 '%keyword%' order by type_desc,name