Online Documentation for SQL Manager for SQL server

Triggers


A Trigger is a special kind of stored procedure that automatically executes when an event occurs in the database server.

 

DML Triggers execute when a user tries to modify data through a data manipulation language (DML) event. DML events are INSERT, UPDATE, or DELETE statements on a table or view.

 

Table triggers are managed within the Triggers tab of Table Editor.

 

 

Creating Triggers

 

To create a new trigger:

  • open the table in Table Editor;
  • proceed to the Triggers tab there;
  • right-click the tab area and select the New Trigger context menu item, or press the Ins key;
  • define the trigger properties using the Trigger Editor dialog.

 

Editing Triggers

 

To edit an existing trigger:

  • open the table in Table Editor;
  • proceed to the Triggers tab there;
  • right-click the trigger and select the Edit Trigger <trigger_name> context menu item, or simply double-click the trigger;
  • edit the trigger properties using the Trigger Editor dialog.

 

Dropping Triggers

 

To drop a trigger:

  • open the table in Table Editor;
  • proceed to the Triggers tab there;
  • right-click the trigger and select the Drop Trigger <trigger_name> context menu item;
  • confirm dropping in the dialog window.