# 查看全部
## 存儲過程
show procedure status;
## 函數(shù)
show function status;
# 查看指定數(shù)據(jù)庫
## 存儲過程
show procedure status where db = 'your_db_name';
select `name` from mysql.proc where db = 'your_db_name' and `type` = 'PROCEDURE';
## 函數(shù)
show function status where db = 'your_db_name';
select `name` from mysql.proc where db = 'your_db_name' and `type` = 'FUNCTION';
# 刪除
## 存儲過程
drop procedure if exists your_procedure_name;
## 函數(shù)
drop function if exists your_function_name;
# 查看創(chuàng)建代碼
## 存儲過程
show create procedure your_procedure_name;
## 函數(shù)
show create function your_function_name;
