How to: Modify Triggers
You can use the Query Builder to edit existing triggers.
Note
This feature is not available for CLR triggers. To modify those, recreate them and redeploy them, replacing the original with the modified version.
Note
The dialog boxes and menu commands you see might differ from those described in Help depending on your active settings or edition. To change your settings, choose Import and Export Settings on the Tools menu. For more information, see Visual Studio Settings.
To insert SQL text with the Query Builder
Right click in the blank area of the SQL Editor window where you want to insert the new SQL.
Click Insert SQL.
The Query Builder comes up where you can work with your stored procedure or user-defined function.
For more information on using Query Builder see Designing Queries and Views.
To modify SQL text with Query Builder
Position the cursor over a block of SQL text.
-or-
Position the cursor over a selected portion of SQL text.
The Query Builder comes up where you can work with your stored procedure or user-defined function.
For more information on using Query Builder see Designing Queries and Views.
See Also
Concepts
Triggers (Visual Database Tools)