查看触发器和存储过程总结

1、查看触发器的个数

SELECT `TRIGGER_NAME` FROM `INFORMATION_SCHEMA`.`TRIGGERS` WHERE `TRIGGER_SCHEMA` = 'question_answer';

2、查看所有触发器状态

show triggers;

3、删除触发器

DROP TRIGGER `question_answer`.`t_weekStatistics_basic_user_i`;

2、查看存储过程的个数

SELECT `SPECIFIC_NAME` FROM `INFORMATION_SCHEMA`.`ROUTINES` WHERE `ROUTINE_SCHEMA` = 'farm' AND ROUTINE_TYPE = 'PROCEDURE';