SQL/MX 3.1 Reference Manual (H06.23+, J06.12+)

Metadata Tables

HP NonStop SQL/MX Release 3.1 Reference Manual—663850-001

10-32

TRIGGERS Table

TRIGGERS is a metadata table in DEFINITION_SCHEMA_VERSION_vernum that

describes triggers:

Column Name Data Type Description

*1 TRIGGER_UID LARGEINT UID of trigger object

2 SUBJECT_CATALOG_UID LARGEINT UID of the catalog of the subject

table

3 SUBJECT_SCHEMA_UID LARGEINT UID of the schema of the subject

table

4 SUBJECT_UID LARGEINT UID of the table on which the trigger

is defined

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