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.
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 open a trigger
In Server Explorer, expand the Tables folder.
Expand the table with the trigger you want to open.
Right-click the name of the trigger that you want to open and choose Open on the shortcut menu.
-or-
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.