Display Triggers in a Database | Teradata Studio - Displaying Triggers in a Database - 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
You can display all of the triggers in a database in the Object List Viewer, and open, modify, disable, or drop a trigger from that view. If you want to create a new trigger, you must first show the table on which you want to define the trigger.
  1. In the Navigator, double-click the Databases category.
    A list of the databases and users in the connected system appears in the Object List Viewer. The list is filtered according to any filters you have applied.
  2. Right-click a database or user, and click Show Triggers.
    The triggers in the database are displayed. The display includes a Table Database column indicating the database containing the table on which the trigger is defined.