查看存储过程、函数、视图和触发器

转自：http://blog.csdn.net/luohai859/article/details/6762948

查询数据库中的存储过程和函数 
方法一： 

select 'name' from mysql.proc where db = 'your_db_name' and `type` = 'PROCEDURE';
select 'name' from mysql.proc where db = 'your_db_name' and `type` = 'FUNCTION';

方法二： 

show procedure status;
show function status;

查看存储过程或函数的创建代码 

show create procedure proc_name; 
show create function func_name; 

查看视图 

SELECT * from information_schema.VIEWS;
SELECT * from information_schema.TABLES;

查看触发器 
方法一： 

语法：SHOW TRIGGERS [FROM db_name] [LIKE expr] 
实例：SHOW TRIGGERS\G

方法二： 

SELECT * FROM information_schema.triggers T WHERE trigger_name="mytrigger"\G