meta_Triggers - Teradata Meta Data Services

Teradata Meta Data Services User Guide

Product
Teradata Meta Data Services
Release Number
15.00
Language
English (United States)
Last Update
2018-09-27
Product Category
Teradata Tools and Utilities

meta_Triggers

Returns the current triggers defined for the repository systems. Corresponds to the relationship DatabaseHasTriggers.

 

Table 145: Columns, Data Types, and Values of the meta_Triggers View  

Column

Data Type

Values

SystemName

VARCHAR(256)

 

DatabaseName

VARCHAR(128)

 

TriggerName

VARCHAR(128)

 

IsSynchronized

VARCHAR(6)

 

TriggerComment

VARCHAR(255)

 

TriggerEnabled

VARCHAR(3)

 

TriggerKind

VARCHAR(14)

  • Each Row
  • Each Statement
  • TriggerEvent

    VARCHAR(6)

  • Delete
  • Insert
  • Update
  • TriggerActionTime

    VARCHAR(12)

  • Before Event
  • After Event
  • TriggerOrder

    SMALLINT

     

    TriggerCreateTime

    TIMESTAMP

     

    TriggerLastEnableDisableTS

    TIMESTAMP

     

    CreatorName

    VARCHAR(128)

     

    TriggerText

    VARCHAR(12500)

     

    TriggerLoid

    INTEGER