Edit a trigger to change the name, trigger events, and other properties.
PrerequisitesÂ
Before you can edit a trigger, be sure the data server that contains the trigger is
running, and you created and established a connection to the data
server.
-
In the Databases folder in Enterprise Explorer, under the database connection profile,
expand the Databases folder, and then expand the tree for a database
and then the tree for the appropriate schema owner.
-
Expand the table that contains the trigger.
-
Under the
Triggers folder, right-click the
trigger, and choose
Edit.
-
Edit the trigger properties.
| Editor
Tab |
Description |
|---|
| General |
- Change the Name.
- Disable the trigger by clicking Disable Trigger, which restricts the database from starting the trigger automatically.
- Select
For Update,
For Insert, or
For Delete to indicate the condition under which the trigger invokes when the associated table is modified.
|
| Source |
Manually edit the SQL code for the trigger in the Source tab. To display line numbers for the SQL code, right-click in the left margin, and select Show Line Numbers. |
| DDL |
View the DDL for the trigger (read-only). |
-
Select
from the main WorkSpace menu.