Online Documentation for SQL Administrator for SQL Server

Trigger Editor

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.

Trigger Editor allows you to specify trigger definition and set trigger properties. It opens automatically when you create a new trigger and is available on editing an existing one.

To open a trigger in Trigger Editor, double-click it in the Triggers list, or use the Edit Trigger... item of the context menu within the Triggers tab of Table Editor.

• Properties
• Options
• Description
• SQL Definition