-- 查看存数过程和函数
-- 语法：
-- 查看存储过程和函数的定义
SHOW CREATE {PROCEDURE|FUNCTION} sp_name;
SHOW CREATE PROCEDURE proc1;
SHOW CREATE FUNCTION func1;-- 查看存储过程和函数的定义
SHOW {PROCEDURE|FUNCTION} STATUS [LIKE 'pattern'];
SHOW PROCEDURE STATUS LIKE 'proc%';
SELECT * FROM information_schema.ROUTINES;
SELECT * FROM information_schema.ROUTINES WHERE ROUTINE_NAME LIKE 'proc%';
SELECT * FROM information_schema.ROUTINES WHERE ROUTINE_TYPE='PROCEDURE' AND ROUTINE_NAME LIKE 'proc%';
SELECT * FROM information_schema.ROUTINES WHERE ROUTINE_TYPE='PROCEDURE';
SELECT * FROM information_schema.ROUTINES WHERE ROUTINE_TYPE='PROCEDURE' AND ROUTINE_SCHEMA='test11';
SHOW FUNCTION STATUS LIKE 'func1';
SELECT * FROM information_schema.ROUTINES;
SELECT * FROM information_schema.ROUTINES WHERE ROUTINE_NAME LIKE 'func1%';
SELECT * FROM information_schema.ROUTINES WHERE ROUTINE_TYPE='FUNCTION' AND ROUTINE_NAME LIKE 'func1%';
SELECT * FROM information_schema.ROUTINES WHERE ROUTINE_TYPE='FUNCTION';
SELECT * FROM information_schema.ROUTINES WHERE ROUTINE_TYPE='FUNCTION' AND ROUTINE_SCHEMA LIKE 'test%';
SHOW PROCEDURE STATUS;
SHOW FUNCTION STATUS;
SELECT * FROM information_schema.ROUTINES;