Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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 SAFETY OFF command and then re-creating the trigger, the old trigger expression is automatically deleted and replaced by the re-created trigger expression.
See Also
Tasks
How to: Remove or Delete Triggers