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.

 

 

Availability:

Full version (for Windows)

Yes

Lite version (for Windows)

No

Note: To compare all features of the Full and the Lite versions of SQL Manager, refer to the Feature Matrix page.