16.00 - Displaying Triggers in a Database - Teradata Studio

Teradata Studio User Guide

prodname
Teradata Studio
vrm_release
16.00
created_date
March 2017
category
User Guide
featnum
B035-2041-126K
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.