This tutorial will show you how to easily manage your Triggers using Database Schema Designer.

---

• Add / Edit a Trigger

  1. If Adding a new Trigger:

     There are a number of methods to add a New Trigger to the Schema.   Choose the one you are most comfortable with:

     • Open Manage Triggers screen and click the "Add" button.   See Manage Schema Objects Tutorial
     • Select "Insert -> Trigger" from the main menu.
       
     • Right Click the Schema and select "New -> Trigger" then choose "with Selected Table/View" to create a Trigger with the last selected Table/View or choose "without Selected Table/View" for a blank Trigger.
       

     If Editing an existing Trigger:

     There are a number of methods to edit an existing Trigger in the Schema.   Choose the one you are most comfortable with:

     • Open Manage Triggers screen and click the "Edit" button with the Constraint selected.   See Manage Schema Objects Tutorial
     • Right Click the Trigger in the Schema Explorer and select "Properties".
       
  2. Editing Trigger Properties
     • If you are Adding a Trigger you can choose the Table from the drop down list.   If you are editing this list will be locked.
       
     • Setup the Trigger Name as required.   See Object Names for more information.
     • Choose the Trigger activation type.
       
     • Choose the Trigger activation action.
       
     • Type the Trigger SQL.
       
     • Click the button to Validate your SQL syntax.  (Not Required)
     • There are a few keyboard shortcuts available for screens that allow direct SQL entry.   See SQL Quick Tips
  3. Click OK to submit your changes.
     - OR -
     Click Cancel to discard your settings.
• Delete a Trigger

  There are a number of methods to delete a Trigger from the Schema.  Choose the one you are most comfortable with:

  • Open the Manage Triggers screen and click Delete with the Trigger selected.   See Manage Schema Objects Tutorial
  • Delete the Trigger's parent Table or View.   See Delete Table Tutorial
  • Right click the Trigger in the Schema Explorer and select Delete.