Online Documentation for SQL Manager for SQL server

DDL Triggers

A Trigger automatically executes when an event occurs in the database server.

DDL Triggers are a special kind of trigger that fire in response to Data Definition Language (DDL) statements. They can be used to perform administrative tasks in the database server.

DDL Trigger Editor allows you to define DDL trigger properties (the scope of the DDL triggers is applied to the current server, i.e. the trigger fires whenever event_type or event_group happens anywhere in the current server). 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. Alternatively, you can right-click the DDL trigger alias and select the Edit DDL Trigger context menu item.

• Using Navigation bar and Toolbar
• Setting DDL trigger properties
• Viewing DDL definition