RDB$TRANSACTIONS

Reserved Words and KeywordsMonitoring Tables

`RDB$TRANSACTIONS`

RDB$TRANSACTIONS stores the states of distributed transactions and other transactions that were prepared for two-phase commit with an explicit prepare message.

Column Name Data Type Description

Column Name	Data Type	Description
`RDB$TRANSACTION_ID`	`INTEGER`	The unique identifier of the transaction being tracked
`RDB$TRANSACTION_STATE`	`SMALLINT`	Transaction state: `0` - in limbo `1` - committed `2` - rolled back
`RDB$TIMESTAMP`	`TIMESTAMP WITH TIME ZONE`	Not used
`RDB$TRANSACTION_DESCRIPTION`	`BLOB`	Describes the prepared transaction and could be a custom message supplied to `isc_prepare_transaction2`, even if it is not a distributed transaction.It may be used when a lost connection cannot be restored

RDB$TRANSACTION_ID

INTEGER

The unique identifier of the transaction being tracked

RDB$TRANSACTION_STATE

SMALLINT

Transaction state:

0 - in limbo
1 - committed
2 - rolled back

RDB$TIMESTAMP

TIMESTAMP WITH TIME ZONE

Not used

RDB$TRANSACTION_DESCRIPTION

BLOB

Describes the prepared transaction and could be a custom message supplied to isc_prepare_transaction2, even if it is not a distributed transaction.It may be used when a lost connection cannot be restored

`RDB$TRIGGERS`

RDB$TRIGGERS stores the trigger definitions for all tables and views.

Column Name Data Type Description

Column Name	Data Type	Description
`RDB$TRIGGER_NAME`	`CHAR(63)`	Trigger name
`RDB$RELATION_NAME`	`CHAR(63)`	The name of the table or view the trigger applies to.NULL if the trigger is applicable to a database event (“database trigger”)
`RDB$TRIGGER_SEQUENCE`	`SMALLINT`	Position of this trigger in the sequence.Zero usually means that no sequence position is specified
`RDB$TRIGGER_TYPE`	`BIGINT`	The event the trigger fires on, see [fblangref-appx04-triggers-type]
`RDB$TRIGGER_SOURCE`	`BLOB TEXT`	Stores the source code of the trigger in PSQL
`RDB$TRIGGER_BLR`	`BLOB BLR`	The binary language representation (BLR) of the trigger code (PSQL trigger only)
`RDB$DESCRIPTION`	`BLOB TEXT`	Trigger comment text
`RDB$TRIGGER_INACTIVE`	`SMALLINT`	Indicates whether the trigger is currently inactive (1) or active (0)
`RDB$SYSTEM_FLAG`	`SMALLINT`	Flag: indicates whether the trigger is user-defined (value 0) or system-defined (value 1 or greater)
`RDB$FLAGS`	`SMALLINT`	Internal use
`RDB$VALID_BLR`	`SMALLINT`	Indicates whether the text of the trigger remains valid after the latest modification by the `ALTER TRIGGER` statement
`RDB$DEBUG_INFO`	`BLOB`	Contains debugging information about variables used in the trigger
`RDB$ENGINE_NAME`	`CHAR(63)`	Engine for external triggers.`'UDR'` for UDR triggers.`NULL` for PSQL triggers
`RDB$ENTRYPOINT`	`CHAR(255)`	The exported name of the external trigger in the trigger library.Note, this is often not the same as `RDB$TRIGGER_NAME`, which is the identifier with which the trigger is declared to the database
`RDB$SQL_SECURITY`	`BOOLEAN`	The `SQL SECURITY` mode (`DEFINER` or `INVOKER`): `NULL` - initial default (`INVOKER`) `FALSE` - `INVOKER` `TRUE` - `DEFINER`

RDB$TRIGGER_NAME

CHAR(63)

Trigger name

RDB$RELATION_NAME

CHAR(63)

The name of the table or view the trigger applies to.NULL if the trigger is applicable to a database event (“database trigger”)

RDB$TRIGGER_SEQUENCE

SMALLINT

Position of this trigger in the sequence.Zero usually means that no sequence position is specified

RDB$TRIGGER_TYPE

BIGINT

The event the trigger fires on, see [fblangref-appx04-triggers-type]

RDB$TRIGGER_SOURCE

BLOB TEXT

Stores the source code of the trigger in PSQL

RDB$TRIGGER_BLR

BLOB BLR

The binary language representation (BLR) of the trigger code (PSQL trigger only)

RDB$DESCRIPTION

BLOB TEXT

Trigger comment text

RDB$TRIGGER_INACTIVE

SMALLINT

Indicates whether the trigger is currently inactive (1) or active (0)

RDB$SYSTEM_FLAG

SMALLINT

Flag: indicates whether the trigger is user-defined (value 0) or system-defined (value 1 or greater)

RDB$FLAGS

SMALLINT

Internal use

RDB$VALID_BLR

SMALLINT

Indicates whether the text of the trigger remains valid after the latest modification by the ALTER TRIGGER statement

RDB$DEBUG_INFO

BLOB

Contains debugging information about variables used in the trigger

RDB$ENGINE_NAME

CHAR(63)

Engine for external triggers.'UDR' for UDR triggers.NULL for PSQL triggers

RDB$ENTRYPOINT

CHAR(255)

The exported name of the external trigger in the trigger library.Note, this is often not the same as RDB$TRIGGER_NAME, which is the identifier with which the trigger is declared to the database

RDB$SQL_SECURITY

BOOLEAN

The SQL SECURITY mode (DEFINER or INVOKER):

NULL - initial default (INVOKER)
FALSE - INVOKER
TRUE - DEFINER