You can copy triggers to a target Teradata system. If you enable the trigger, you can specify whether to place the trigger on the target table before or after the table is loaded.
- In the Objects tab, click to expand the tree.
- Click to expand a database or user object where the trigger is located.
- To filter so only triggers display, do the following:
- Click and clear all check marks except for Trigger.
- Move the cursor away from the object-types filter to refresh the tree with triggers in the sub-branch.
- Click to display the Trigger Settings dialog box.
- [Optional] To activate the trigger and designate when to place it on the target table, select Enabled and do one of the following from the Action Time list:
- Select BEFORE to place the trigger on the target table before the table is loaded. A trigger action occurs for each row that is copied from the source.
- Select AFTER from the Action Time list to place the trigger on the target table after the table is loaded. No trigger action occurs for rows that are copied from the source.
- Select OK.