Choose your database:
AnySQL
MySQL
MS SQL Server
PostgreSQL
SQLite
Firebird
Oracle
SQL Anywhere
DB2
MaxDB

Subscribe to our news:
Partners
Testimonials
Carl Schammel: "I have been in search of a software product that was rich in features and easy for using, but was unable to find one until I came upon Firebird Maestro. Not only does it have all-inclusive integrated functionality, but SQL Maestro Group have provided me with superior support. I now have the management tools at my hand that I have been looking for".
Brian Vivian: "Thank you very much for making such a great product. It makes my job a LOT easier".

More

Add your opinion

Firebird Maestro online Help

Prev Return to chapter overview Next

Editing DDL trigger properties

Specify DDL Trigger options according to your needs. The detailed description is given below.
 

Definition

The field contains the definition of the DDL trigger. It describes the trigger conditions and actions. The trigger actions specified in the Transact-SQL statements go into effect when the DDL operation is tried. Triggers can include any number and kind of Transact-SQL statements, with exceptions.

 

Name

Displays the DDL trigger name.

 

Comment

Specify a comment to the DDL trigger.

 

Events

This field allows you to specify the events execution of which causes a DDL trigger to fire. Click ellipse button (...) on the right of the events text area to select this events or event groups using the Add Event Dialog.

 

 Active

Disabling a trigger does not drop it. The DDL trigger still exists as an object in the current database/server.

 

Use the Position clause to modify the order in which multiple triggers on the same situation fire.

 

To apply the changes, select the Apply Changes item in the Navigation bar or use Ctrl+F9 or Ctrl+F7 shortcut keys.

 

It is also possible to modify object properties without opening the object editor: use the Object Properties item of the popup menu of the selected object from the explorer tree.



Prev Return to chapter overview Next