Copy Triggers Steps | Teradata Data Mover - 17.11 - Copying Triggers - Teradata Data Mover

Teradata® Data Mover User Guide

Product
Teradata Data Mover
Release Number
17.11
Release Date
October 2021
Content Type
User Guide
Publication ID
B035-4101-091K
Language
English (United States)
  1. Copy a trigger from a source database to a target database by specifying the selection="included" attribute of the trigger tag.
    You cannot relocate or rename triggers.
Example:
<triggers>
<trigger selection= "included">
			<database>west1000</database>
			<subject_table_database>west1000</subject_table_database>
			<table>employee</table>
			<name>RaiseTrig</name>
			<action_time enabled="NO">BEFORE</action_time>
</trigger>
</triggers>