EMS logo

Produits

SQL Manager for SQL Server

Notre statut de partenariat

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS SQL Manager for SQL Server

Documentation en ligne

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.