Skip to main content

Triggers, dependencies

SYS.TRIGGERS
name type references description
"id" INTEGER   The internal trigger identifier.
"name" VARCHAR   Its SQL name.
"table_id" INTEGER sys.tables.id The corresponding triggering table identifier
"time" SMALLINT  

BEFORE/AFTER

"orientation" SMALLINT   FOR EACH ROW/FOR EACH STATEMENT
"event" SMALLINT   Update/insert/delete event.
"old_name" VARCHAR   The correlation SQL name for the previous state.
"new_name" VARCHAR   The correlation SQL name for the previous state.
"condition" VARCHAR   The SQL condition.
"statement" VARCHAR   A SQL statement to be executed.
SYS.DEPENDENCIES
name type references description
"id" INTEGER   The internal dependencies identifier.
"depend_id" INTEGER sys.dependencies.id Corresponding recurvive dependency reference.
"depend_type" SMALLINT   Function, procedure, schema, owner, table, view, column.