TMP$TRIGGERS
From InterBase
Go Up to System Temporary Tables
The TMP$TRIGGERS table contains one row for each trigger executed since the current connection began.
| 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
|
Pool memory size |
TMP$CLONE
|
SMALLINT
|
Cloned instance number | ||
TMP$TIMESTAMP
|
TIMESTAMP
|
Start time of trigger | ||
TMP$QUANTUM
|
INTEGER
|
DOUBLE PRECISION | NUMERIC
|
Units of Execution |
TMP$INVOCATIONS
|
INTEGER
|
DOUBLE PRECISION | NUMERIC
|
Number of calls to trigger |
TMP$PAGE_READS
|
INTEGER
|
DOUBLE PRECISION | NUMERIC
|
Page reads all database file |
TMP$PAGE_WRITES
|
INTEGER
|
DOUBLE PRECISION | NUMERIC
|
Page writes all database files |
TMP$PAGE_FETCHES
|
INTEGER
|
DOUBLE PRECISION | NUMERIC
|
Page fetches all database files |
TMP$PAGE_MARKS
|
INTEGER
|
DOUBLE PRECISION | NUMERIC
|
Page marks all database files |
TMP$RECORD_SELECTS
|
INTEGER
|
DOUBLE PRECISION | NUMERIC
|
Records selected by trigger |
TMP$RECORD_INSERTS
|
INTEGER
|
DOUBLE PRECISION | NUMERIC
|
Records inserted by trigger |
TMP$RECORD_UPDATES
|
INTEGER
|
DOUBLE PRECISION | NUMERIC
|
Records updated by trigger |
TMP$RECORD_DELETES
|
INTEGER
|
DOUBLE PRECISION | NUMERIC
|
Records deleted by procedure |
TMP$RECORD_PURGES
|
INTEGER
|
DOUBLE PRECISION | NUMERIC
|
Garbage collect record purges |
TMP$RECORD_EXPUNGES
|
INTEGER
|
DOUBLE PRECISION | NUMERIC
|
Garbage collect record expunges |
TMP$RECORD_BACKOUTS
|
INTEGER
|
DOUBLE PRECISION | NUMERIC
|
Garbage collect record backout |