Thursday, December 12, 2013

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