ALL TRIGGERS in db

SELECT * FROM information_schema.triggers WHERE information_schema.triggers.trigger_schema LIKE '%dbname%'



You can use this to create drop statements or save the definitions.


Till Next Time

Welcome to MYSQL101

Hi, My name is John Minkjan and I'm a senior BI-consultant at CIBER in the Netherlands. I reserverd a couple of ...101 blogspots. At the moment I'm mostly active on OBIEE101. I will start posting here as soon as my focus in back on MySql databases.
Till Next Time
John