17.10 - Triggers - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - Data Dictionary

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Programming Reference
Publication ID
English (United States)

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