Creating a Trigger - Teradata Studio

Teradata Studio User Guide

Product
Teradata Studio
Release Number
15.11
Published
May 2016
Language
English (United States)
Last Update
2018-05-03
dita:mapPath
bpb1467322243715.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2041
lifecycle
previous
Product Category
Teradata Tools and Utilities
Triggers automatically perform SQL operations in response to INSERT, UPDATE, DELETE, or MERGE modifications of the tables on which they are defined.
  1. In the Navigator, right-click the database or user that contains the table for which you want to define a trigger, and click Show Tables. A list of the tables the database or user contains appears in the Object List Viewer.
  2. In the Object List Viewer, right-click the table for which you want to define a trigger, and click Show Triggers. Any triggers that have been defined for the table are listed in the Object List Viewer.
  3. In the Object List Viewer, click . A Create Trigger property form opens in the Details view.
  4. Enter the properties that define your new trigger. For more information on creating triggers, see SQL Data Definition Language and SQL Fundamentals.
  5. [Optional] Click the SQL tab to see the SQL code that will be executed on the connected system to create the new trigger.
  6. Click Commit. If an error is returned, modify your trigger properties to address the error. The trigger is created in the connected database.
  7. Click OK. A property form shows the new trigger properties.