データウェアハウス010-MySQLすべてのストアド・プロシージャ、関数、ビュー、トリガを表示

1.              
   :
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;



2.    
SELECT * from information_schema.VIEWS   //  
SELECT * from information_schema.TABLES   // 



3.     
   :
  ：SHOW TRIGGERS [FROM db_name] [LIKE expr]
  ：SHOW TRIGGERS\G     //   

   :
 INFORMATION_SCHEMA     TRIGGERS   
mysql>SELECT * FROM triggers T WHERE trigger_name=”mytrigger” \G