Displaying Triggers in a Database - Teradata Studio

Teradata Studio User Guide

Product
Teradata Studio
Release Number
16.00
Published
March 2017
Language
English (United States)
Last Update
2018-03-29
dita:mapPath
hop1484765174877.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.