Triggers Table

Structure

CREATE TABLE "Triggers"
(
"TableName" VARCHAR(40) COLLATE "ANSI_CI",
"Name" VARCHAR(40) COLLATE "ANSI_CI",
"Description" CLOB COLLATE "ANSI",
"ActionTime" VARCHAR(15) COLLATE "ANSI_CI",
"ActionType" VARCHAR(15) COLLATE "ANSI_CI",
"Condition" CLOB COLLATE "ANSI",
"Definition" CLOB COLLATE "ANSI",
"Enabled" BOOLEAN,
"OrdinalPos" INTEGER,
"CreateSQL" CLOB COLLATE "ANSI_CI",
"DropSQL" CLOB COLLATE "ANSI_CI"
)

CREATE INDEX "TableName" ON "Triggers"
("TableName")

CREATE INDEX "Name" ON "Triggers"
("Name")

Description

This table contains the defined triggers for the tables in an ElevateDB database.

The ActionTime column values are as follows:

ActionTime

Description

Before	The trigger will be executed before the type of operation for which the trigger is defined
After	The trigger will be executed after the type of operation for which the trigger is defined
Error	The trigger will be executed after any error with the type of operation for which the trigger is defined

The ActionType column values are as follows:

ActionType

Description

Insert	The trigger will be executed for any insert operation
Update	The trigger will be executed for any update operation
Delete	The trigger will be executed for any delete operation
All	The trigger will be executed for all operations (universal trigger)

Related DDL Statements

Statement

Description

CREATE TRIGGER	Creates a new trigger
ALTER TRIGGER	Alters an existing trigger
DROP TRIGGER	Drops an existing trigger
RENAME TRIGGER	Renames an existing trigger

More Support Options

Support Forums

Frequently Asked Questions

Technical Bulletins

Technical Articles

Incident Reports

Roadmap