Trigger Class Property Descriptions - Teradata Meta Data Services

Property Name

Description

ActionTime

Action time for the trigger:

A = After the trigger event
B = Before the trigger event
I = Instead of the trigger event

CommentString

The comment stored in Teradata for the trigger

CreatorName

The Teradata user that created the trigger

DatabaseId

Teradata assigned identifier for the database where this trigger resides

Event

Type of SQL DML statement that causes trigger to fire:

D = Delete
I = Insert
U = Update

IsEnabled

Indicates whether the trigger is activated or not:

Y = Enabled
N= Disabled

Kind

Trigger kind as defined by the FOR EACH clause:

R = Row
S = Statement

LastAlterTimeStamp

Time that Teradata last updated the object

OrderingPosition

When one or more triggers are defined on the same table, ORDER allows you to determine the sequence for firing each trigger.

RequestText

Contains the text that created the trigger

SynchronizationLevel

Internal Flag:

0 = Invalid references detected
1 = all information complete
-2 = QuickLoaded trigger

TriggerId

Teradata assigned identifier for this trigger