Copying the SQL for a triggered action

You can use the Control Center to copy a triggered-action clause from an existing trigger to a new one. You might do this to facilitate the altering of a trigger's definition, or to save the time that it takes to type the clause.

To copy a triggered-action clause:

1. Display and select the text that you want to copy:
   1. Open the Alter Trigger notebook.
   2. Click on the Triggered Action tab. The Triggered Action page opens, displaying the definition of the selected trigger in the Trigger statement field.
   3. In the Trigger statement field, select the text that you want to copy and press Ctrl+Insert.
   4. Click on Close to close the Alter Trigger notebook.
2. Optional: Drop the trigger that you just displayed.
3. Copy the selected text to a new trigger; complete the new trigger:
   1. Open the Create Trigger notebook.
   2. Click on the Triggered Action tab. The Triggered Action page opens, displaying a template for the triggered-action clause in the Triggered action field.
   3. Erase any part of the template that you don't need, or click on Clear to remove the template.
   4. In the Triggered action field, place the cursor at the point at which you want to insert the text to be copied, and press Shift+Insert. The text is copied.
   5. Use the Trigger page and the Triggered Action page to finish creating the trigger.