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' //函数
1
2
3
方法二:
show procedurestatus;//存储过程
show functionstatus;//函数
1
2
查看存储过程或函数的创建代码
show createprocedureproc_name;
show createfunctionfunc_name;
1
2
二、.查看视图
SELECT * from information_schema.VIEWS //视图SELECT * from information_schema.TABLES //表