>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.
>
You don't need to actually delete the trigger code, only the reference to the trigger function.
To find what the trigger is, use
lcTriggerVal = DBGETPROP("MyTable", "Table", "DeleteTrigger")
when you are donw with your processing, build a string like:
recreate the trigger with:
CREATE TRIGGER ON MyTable FOR DELETE AS (lctriggerVal)
Erik Moore
Clientelligence