>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)