js editor
Web development
You can modify triggers through the Table Designer or through the language.
To modify a trigger
-
In the Table tab of the Table Designer, enter the new trigger expression in the Insert trigger, Update trigger, or Delete trigger box.
-or-
-
Issue the SET SAFETY OFF command, and then use the CREATE TRIGGER Command.
When you modify a trigger by first issuing the SET SAFETYOFF command and then re-creating the trigger, the old trigger expression is automatically deleted and replaced by the re-created trigger expression.