Triggers Editor (SQL Server)

From RapidSQL
Jump to: navigation, search

Go Up to Microsoft SQL Server Object Editors

The Triggers Editor lets you enable and disable a trigger, view and modify the CREATE TRIGGER statement that will implement changes, and manage dependencies.

To edit a trigger

  1. Open an editor on the trigger. For details, see Opening an Object Editor.
  2. Use the following table as a guide to understanding and modifying the settings on the tabs of this editor:
Tab Settings and tasks

Properties

Lets you set the Enabled property. It also lets you view the Trigger Timing (AFTER, INSTEAD OF), Fire On Insert, Fire On Update, Fire On Delete, and Encrypted properties.

Definition

Lets you modify the CREATE TRIGGER body for a trigger. To modify a trigger, edit the text of the trigger body in the Trigger Text area. The existing trigger is automatically dropped and then recreated.

Dependencies

For details on using this tab, see Working with Object Dependencies.

3. When finished, you can submit your changes. For details, see Previewing and Submitting Object Editor Changes.