Modifying a Trigger - Teradata Studio
Teradata® Studio™ User Guide
- Product
- Teradata Studio
- Release Number
- 16.20
- Published
- September 2019
- Language
- English (United States)
- Last Update
- 2019-10-10
- dita:mapPath
- pfg1542649412202.ditamap
- dita:ditavalPath
- ft:empty
- dita:id
- B035-2041
- lifecycle
- previous
- Product Category
- Teradata Tools and Utilities
-
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.
-
In the Object List Viewer:
-
Right-click the table for which you want to modify a trigger, and click Show Triggers.
-
Right-click the trigger you want to modify, and click Modify Trigger.
-
Modify properties by entering new information into the property fields.
-
[Optional] Click the SQL tab to see the SQL code that will be executed on the connected system to modify the trigger.
-
Click Commit.
If an error is returned, modify your trigger properties to address the error.
-
Click OK.