Create a Trigger | Teradata Studio - Creating a Trigger - Teradata Studio

Teradata® Studio™ User Guide - 17.20

Product
Teradata Studio
Release Number
17.20
Published
September 2022
Language
English (United States)
Last Update
2022-09-23
dita:mapPath
gvw1648839236371.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2041
Product Category
Teradata Tools and Utilities
  1. In the Navigator, expand Databases, right-click the database or user that contains the table for which you want to define a trigger, and click Show Tables.
  2. In the Object List Viewer:
    1. Right-click the table for which you want to define a trigger, and click Show Triggers.
    2. Click "" .
  3. Enter the properties for the new trigger.
    For more information, see Teradata Vantage™ - SQL Data Definition Language Syntax and Examples, B035-1144 and Teradata Vantage™ - SQL Fundamentals, B035-1141.
  4. [Optional] Click the SQL tab to see the SQL code that will be executed on the connected system to create the new trigger.
  5. Click Commit.
    If an error is returned, modify your trigger properties to address the error.
  6. Click OK.