Database Trigger Editor
|Previous Index Next How To Use|
Database Triggers are pieces of code that are executed automatically by the database engine before or after certain actions occur on a database, eg "on connect" or "on create table".
The Database Trigger Editor offers the possibility to create, alter and drop database triggers. If you add or drop a trigger, the Database Triggers node in the Database Navigator tree-view will display the change as well by adding or deleting the database trigger from the list.
Below is an example of the MS SQL Database Trigger Editor:
MS SQL Server Database Trigger Editor
When you click the flashlight button, a Select Database Events dialog is shown.
Select events from a convenient tree
As you can see, you can select the events you want and Database Workbench will use the shortest option available. That is, if a "parent" node is selected, not the values for each child node will be used, but rather the parent value.