search

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

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

WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWB
WBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOYWBOriginal
2016-06-07 14:56:321688browse

关键字查找相关的存储过程、触发器、函数和视图 无 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
Statement：
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Previous article：Oracle做学生信息系统的脚本Next article：MySQL存储过程实现split

Related articles

See more