Online Documentation for SQL Manager for SQL server

DDL Triggers

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


DDL Triggers fire in response to a variety of data definition language (DDL) events which are primarily CREATE, ALTER and DROP statements; logon triggers fire in response to the LOGON event that is raised when a user sessions is being established.


DDL Trigger Editor allows you to define DDL trigger properties (the scope of the DDL triggers is applied to the current database, i.e. the trigger fires whenever event_type or event_group happens in the current database). It opens automatically when you create a new DDL trigger and is available on editing an existing one.


To open a DDL trigger in DDL Trigger Editor, double-click it in the DB Explorer tree.