Home
SQL programmingYou can use the HCL OneDB™ implementation of the SQL language to develop applications for HCL OneDB™ database servers.
Guide to SQL: SyntaxThe HCL OneDB™ Guide to SQL: Syntax describes the syntax of the statements, data types, expressions, operators, and built-in functions of the HCL OneDB™ dialect of the SQL language.
SQL statementsThis chapter describes the syntax and semantics of SQL statements that are recognized by HCL OneDB™.
CREATE TRIGGER statementUse the CREATE TRIGGER statement to define a trigger on a table. You can also use CREATE TRIGGER to define an INSTEAD OF trigger on a view.
Defining a Trigger Event and Action

Defining a Trigger Event and Action

This syntax defines the event and action of a trigger on a table or on a view.

Trigger on a Table

DELETE and SELECT Clauses

UPDATE Clause

Trigger on a View

Notes:

¹ See REFERENCING Clause for Insert triggers
² See Correlated Table Action
³ See Action Clause
⁴ See REFERENCING Clause for Update
⁵ See INSTEAD OF Triggers on Views


Element	Description	Restrictions	Syntax
column	The name of a column in the triggering table	Must exist	Identifier
correlation	Name that you declare here to qualify an old or new column value (as correlation.column) in a triggered action	Must be unique in this trigger	Identifier
table, view	Name or synonym of the triggering table or view. The table or view can include an owner. qualifier.	Must exist in the current database	Identifier

The left-hand portion of the main diagram (including the table or view) defines the trigger event (sometimes called the triggering event). The rest of the diagram declares correlation names and defines the trigger action (sometimes called the triggered action).

For the syntax to specify the triggered action of triggers on tables, see Action Clause and Correlated Table Action.

For the syntax to specify the triggered action of INSTEAD OF triggers on views, see The Action Clause of INSTEAD OF Triggers.