17.00 - Triggers - Teradata Database

Teradata Vantageā„¢ - Data Dictionary

prodname
Advanced SQL Engine
Teradata Database
vrm_release
17.00
created_date
June 2020
category
Administration
Programming Reference
featnum
B035-1092-170K

The Trigger objects in the database contain:

  • IDs of the:
    • Table
    • Trigger
    • Database and subject table database
    • User who created the trigger
    • User who last updated the trigger
  • Timestamp for the last update
  • Indexes
  • Trigger name and:
    • Whether the trigger is enabled
    • The event that fires the trigger
    • The order in which triggers fire
  • Default character set
  • Creation text and time stamp
  • Overflow text, that is, trigger text that exceeds a specified limit
  • Fallback tables