批量删除数据库中触发器 存储过程 事件

批量删除数据库中触发器 存储过程 事件

SELECT CONCAT('DROP TRIGGER IF EXISTS `', TRIGGER_SCHEMA, '`.`', TRIGGER_NAME, '`;')
FROM INFORMATION_SCHEMA.TRIGGERS
WHERE TRIGGER_SCHEMA = 'schem_name';

SELECT CONCAT('DROP PROCEDURE IF EXISTS ', ROUTINE_NAME, ';')
FROM INFORMATION_SCHEMA.ROUTINES
WHERE ROUTINE_TYPE = 'PROCEDURE'
AND ROUTINE_SCHEMA = DATABASE();

SELECT CONCAT('DROP EVENT IF EXISTS `', EVENT_NAME, '`;')

FROM INFORMATION_SCHEMA.EVENTS 

WHERE EVENT_SCHEMA = 'your_database_name';