FirebirdSQL logo
 Reserved Words and KeywordsMonitoring Tables 

RDB$TRIGGER_TYPE Value

The value of RDB$TRIGGER_TYPE is built from:

1

before insert
2

after insert
3

before update
4

after update
5

before delete
6

after delete
17

before insert or update
18

after insert or update
25

before insert or delete
26

after insert or delete
27

before update or delete
28

after update or delete
113

before insert or update or delete
114

after insert or update or delete
8192

on connect
8193

on disconnect
8194

on transaction start
8195

on transaction commit
8196

on transaction rollback
Note

Identification of the exact RDB$TRIGGER_TYPE code is a little more complicated, since it is a bitmap, calculated according to which phase and events are covered and the order in which they are defined.For the curious, the calculation is explained in this code comment by Mark Rotteveel.

For DDL triggers, the trigger type is obtained by bitwise OR above the event phase (0 — BEFORE, 1 — AFTER) and all listed types events:

0x0000000000004002

CREATE TABLE
0x0000000000004004

ALTER TABLE
0x0000000000004008

DROP TABLE
0x0000000000004010

CREATE PROCEDURE
0x0000000000004020

ALTER PROCEDURE
0x0000000000004040

DROP PROCEDURE
0x0000000000004080

CREATE FUNCTION
0x0000000000004100

ALTER FUNCTION
0x0000000000004200

DROP FUNCTION
0x0000000000004400

CREATE TRIGGER
0x0000000000004800

ALTER TRIGGER
0x0000000000005000

DROP TRIGGER
0x0000000000014000

CREATE EXCEPTION
0x0000000000024000

ALTER EXCEPTION
0x0000000000044000

DROP EXCEPTION
0x0000000000084000

CREATE VIEW
0x0000000000104000

ALTER VIEW
0x0000000000204000

DROP VIEW
0x0000000000404000

CREATE DOMAIN
0x0000000000804000

ALTER DOMAIN
0x0000000001004000

DROP DOMAIN
0x0000000002004000

CREATE ROLE
0x0000000004004000

ALTER ROLE
0x0000000008004000

DROP ROLE
0x0000000010004000

CREATE INDEX
0x0000000020004000

ALTER INDEX
0x0000000040004000

DROP INDEX
0x0000000080004000

CREATE SEQUENCE
0x0000000100004000

ALTER SEQUENCE
0x0000000200004000

DROP SEQUENCE
0x0000000400004000

CREATE USER
0x0000000800004000

ALTER USER
0x0000001000004000

DROP USER
0x0000002000004000

CREATE COLLATION
0x0000004000004000

DROP COLLATION
0x0000008000004000

ALTER CHARACTER SET
0x0000010000004000

CREATE PACKAGE
0x0000020000004000

ALTER PACKAGE
0x0000040000004000

DROP PACKAGE
0x0000080000004000

CREATE PACKAGE BODY
0x0000100000004000

DROP PACKAGE BODY
0x0000200000004000

CREATE MAPPING
0x0000400000004000

ALTER MAPPING
0x0000800000004000

DROP MAPPING
0x7FFFFFFFFFFFDFFE

ANY DDL STATEMENT

For example a trigger with
BEFORE CREATE PROCEDURE OR CREATE FUNCTION will be of type 0x0000000000004090,
AFTER CREATE PROCEDURE OR CREATE FUNCTION — 0x0000000000004091,
BEFORE DROP FUNCTION OR DROP EXCEPTION — 0x00000000000044200,
AFTER DROP FUNCTION OR DROP EXCEPTION — 0x00000000000044201,
BEFORE DROP TRIGGER OR DROP DOMAIN — 0x00000000001005000,
AFTER DROP TRIGGER OR DROP DOMAIN — 0x00000000001005001.

RDB$TRIGGER_MESSAGES

RDB$TRIGGER_MESSAGES stores the trigger messages.

Column Name Data Type Description

RDB$TRIGGER_NAME

CHAR(63)

The name of the trigger the message is associated with

RDB$MESSAGE_NUMBER

SMALLINT

The number of the message within this trigger (from 1 to 32,767)

RDB$MESSAGE

VARCHAR(1023)

Text of the trigger message