Hi everyone.

I want to temporarily "deactivate" the triggers on tables for performance reasons.

I know about the DELETE TRIGGER and CREATE TRIGGER commands. What I cannot seem to find is a function that will return me the current value of the trigger. What I want to do is store the triggers in a temporary table, delete them, do my processing and then re-set the triggers based on what I have in the temporary table.

Maybe this is not the right way to go, if someone have a suggestion, feel free to give me your input.

Thanks in advance.

Eric Dumais.