Modify a Trigger | Teradata Studio - Modifying a Trigger - Teradata Studio

Teradata® Studio™ User Guide

Product
Teradata Studio
Release Number
17.00
Published
January 2021
Language
English (United States)
Last Update
2021-01-11
dita:mapPath
lex1576517377362.ditamap
dita:ditavalPath
ft:empty
dita:id
B035-2041
lifecycle
previous
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 modify a trigger, and click Show Tables.
  2. In the Object List Viewer:
    1. Right-click the table for which you want to modify a trigger, and click Show Triggers.
    2. Right-click the trigger you want to modify, and click Modify Trigger.
  3. Modify properties by entering new information into the property fields.
  4. [Optional] Click the SQL tab to see the SQL code that will be executed on the connected system to modify the trigger.
  5. Click Commit.
    If an error is returned, modify your trigger properties to address the error.
  6. Click OK.