SQL/MX 3.2 Reference Manual (H06.25+, J06.14+)
Metadata Tables
HP NonStop SQL/MX Release 3.2 Reference Manual—691117-001
10-33
TRIGGERS Table
5 ACTIVATION_TIME CHAR(2) Activation time:
B Before
A After
6 OPERATION CHAR(2) Operation that fires the trigger:
I INSERT
D DELETE
U UPDATE
7 GRANULARITY CHAR(2) Granularity:
R Row
S Statement
8 COLUMNS_IMPLICIT CHAR(2) Relevant only for UPDATE trigger:
Y Yes
N No
9 ENABLED CHAR(2) Current status of trigger:
Y if enabled
N if not
10 TRIGGER_CREATED LARGEINT Timestamp of creation of the trigger
* Indicates primary key
Column Name Data Type Description










