Edit an INSTEAD OF trigger to change the name, trigger events, and other properties.
PrerequisitesÂ
Be sure the data server that contains the trigger is
running, and that you have created and established a connection to the data
server.
-
In Enterprise Explorer, expand the view that contains the INSTEAD OF trigger.
-
In the
Instead of Triggers folder, right-click the
trigger, and choose
Edit.
-
Edit the INSTEAD OF trigger properties.
Editor
tab |
Description |
General |
- Change the Name.
- Select
Instead of Insert,
Instead of Update, or
Instead of Delete to indicate the condition under which the trigger invokes when the associated view is modified.
|
Source |
Manually edit the SQL code for the trigger. 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.
-
Click Save in the Preview Changes window to execute the SQL code and save the changes to the database.
The Preview Changes window appears unless the option is unselected through the Schema Object Editor Configuration preference page.