How to: Open a Trigger

You can open a trigger to view or edit the text of an existing trigger that is stored in your database. Triggers are scripted in Transact-SQL for Microsoft SQL Server databases or PL/SQL for Oracle databases.

A trigger is differentiated from the database table columns in Server Explorer by the trigger icon.


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 open a trigger

  1. In Server Explorer, expand the Tables folder.

  2. Expand the table with the trigger you want to open.

  3. Right-click the name of the trigger that you want to open and choose Open on the shortcut menu.


    Double-click the name of the trigger that you want to open.

    The trigger is opened in a source code editor that you can use to edit the SQL statements.

Community Additions