Structure

---

CREATE TABLE "TriggerColumns"
(
"TableName" VARCHAR(40) COLLATE "ANSI_CI",
"TriggerName" VARCHAR(40) COLLATE "ANSI_CI",
"ColumnName" VARCHAR(40) COLLATE "ANSI_CI",
"OrdinalPos" INTEGER
)

CREATE INDEX "TableName" ON "TriggerColumns"
("TableName")

CREATE INDEX "TriggerName" ON "TriggerColumns"
("TriggerName")

CREATE INDEX "ColumnName" ON "TriggerColumns"
("ColumnName")

Description

---

This table contains the columns that make up the defined update triggers for the tables in an ElevateDB database. Update triggers can be created so that they fire only when specific columns are updated.

Related DDL Statements

---