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
Your computer might show different names or locations for some of the Visual Studio user interface elements in the following instructions. The Visual Studio edition that you have and the settings that you use determine these elements. For more information, see Customizing Development Settings in Visual Studio.
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
Reference
Concepts
Triggers (Visual Database Tools)