ITPub博客

查看存储过程函数名：存储过程：（注意字段name,type两边是ESC下面那个键）select `name` from mysql.proc where db = 'your_db_name' and `type` = 'PROCEDURE' show procedure status; 函数：select `name` from mysql.proc where db = 'your_db_name' and `type` = 'FUNCTION' show function status; 查看存储过程、函数代码：show create procedure proc_name;show create function func_name;查看视图：SELECT * from information_schema.VIEWS 查看表：SELECT * from information_schema.TABLES //表查看触发器：方法一：语法：SHOW