MY_TRIGGERS

owner

character varying(128)

Trigger owner.

trigger_name

character varying(64)

Trigger name.

trigger_type

character varying

Trigger type, which can be before statement, before each row, after statement, after each row, or instead of.

triggering_event

character varying

Event that triggers a trigger. The value can be update, insert, delete, or truncate.

table_owner

character varying(64)

Owner of the table that defines a trigger.

base_object_type

character varying(18)

Basic object type of a trigger, which can be table or view.

table_name

character varying(64)

Name of the table or view that defines a trigger.

column_name

character varying(4000)

Not supported. Set it to NULL.

referencing_name

character varying(422)

Not supported. Set it to referencing new as new old as old.

when_clause

character varying(4000)

Content of when. TRUE must be evaluated as TRIGGER_BODY to execute.

status

character varying(64)

• O: The trigger is enabled in origin or local mode.
• D: The trigger is disabled.
• R: The trigger is enabled in replica mode.
• A: The trigger is always enabled.

description

character varying(4000)

Trigger description, which is used to rebuild a trigger creation statement.

action_type

character varying(11)

Action type of a trigger, which only supports call.

trigger_body

text

Statement executed when a trigger is triggered.

crossedition

character varying(7)

Not supported. Set it to NULL.

before_statement

character varying(3)

Not supported. Set it to NULL.

before_row

character varying(3)

Not supported. Set it to NULL.

after_row

character varying(3)

Not supported. Set it to NULL.

after_statement

character varying(3)

Not supported. Set it to NULL.

instead_of_row

character varying(3)

Not supported. Set it to NULL.

fire_once

character varying(3)

Not supported. Set it to NULL.

apply_server_only

character varying(3)

Not supported. Set it to NULL.