TMP$TRIGGERS

From InterBase
Jump to: navigation, search

Go Up to System Temporary Tables


The TMP$TRIGGERS table contains one row for each trigger executed since the current connection began.

TMP$TRIGGERS
Column name Data Type for <=ODS 15 Data Type for >=ODS 16, dialect 1 Data Type for >=ODS 16, dialect 3 Description

TMP$TRIGGER_ID

INTEGER

Trigger identifier

TMP$DATABASE_ID

INTEGER

Database identifier

TMP$RELATION_NAME

CHAR[67]

Relation name for trigger

TMP$TRIGGER_NAME

CHAR[67]

Trigger name

TMP$TRIGGER_TYPE

SMALLINT

The type of trigger being defined Values are:

1 - BEFORE INSERT

2 - AFTER INSERT

3 - BEFORE UPDATE

4 - AFTER UPDATE

5 - BEFORE DELETE

6 - AFTER DELETE

TMP$TRIGGER_SEQUENCE

SMALLINT

Sequence number for the trigger being defined; determines when a trigger is executed in relation to others of the same type.

Triggers with the same sequence number execute in alphabetic order by trigger name.

If this number is not assigned by the user, InterBase assigns a value of 0.

TMP$TRIGGER_ORDER

CHAR[31]

Position of the trigger

TMP$TRIGGER_OPERATION

CHAR[31]

UPDATE, DELETE or INSERT

TMP$POOL_ID

INTEGER

Pool identifier

TMP$POOL_MEMORY

INTEGER

DOUBLE PRECISION

NUMERIC

(18,0)

Pool memory size

TMP$CLONE

SMALLINT

Cloned instance number

TMP$TIMESTAMP

TIMESTAMP

Start time of trigger

TMP$QUANTUM

INTEGER

DOUBLE PRECISION

NUMERIC

(18,0)

Units of Execution

TMP$INVOCATIONS

INTEGER

DOUBLE PRECISION

NUMERIC

(18,0)

Number of calls to trigger

TMP$PAGE_READS

INTEGER

DOUBLE PRECISION

NUMERIC

(18,0)

Page reads all database file

TMP$PAGE_WRITES

INTEGER

DOUBLE PRECISION

NUMERIC

(18,0)

Page writes all database files

TMP$PAGE_FETCHES

INTEGER

DOUBLE PRECISION

NUMERIC

(18,0)

Page fetches all database files

TMP$PAGE_MARKS

INTEGER

DOUBLE PRECISION

NUMERIC

(18,0)

Page marks all database files

TMP$RECORD_SELECTS

INTEGER

DOUBLE PRECISION

NUMERIC

(18,0)

Records selected by trigger

TMP$RECORD_INSERTS

INTEGER

DOUBLE PRECISION

NUMERIC

(18,0)

Records inserted by trigger

TMP$RECORD_UPDATES

INTEGER

DOUBLE PRECISION

NUMERIC

(18,0)

Records updated by trigger

TMP$RECORD_DELETES

INTEGER

DOUBLE PRECISION

NUMERIC

(18,0)

Records deleted by procedure

TMP$RECORD_PURGES

INTEGER

DOUBLE PRECISION

NUMERIC

(18,0)

Garbage collect record purges

TMP$RECORD_EXPUNGES

INTEGER

DOUBLE PRECISION

NUMERIC

(18,0)

Garbage collect record expunges

TMP$RECORD_BACKOUTS

INTEGER

DOUBLE PRECISION

NUMERIC

(18,0)

Garbage collect record backout

Advance To: