How to: Modify Triggers

  • Article

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

  1. Right click in the blank area of the SQL Editor window where you want to insert the new SQL.

  2. 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

Trigger (DML) Properties

Concepts

Triggers (Visual Database Tools)

Other Resources

Working with Triggers