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™.
SET TRIGGERS statementUse the SET TRIGGERS statement to enable or disable all or some of the triggers on a table, or all or some of the INSTEAD OF triggers on a view.

SET TRIGGERS statement

Use the SET TRIGGERS statement to enable or disable all or some of the triggers on a table, or all or some of the INSTEAD OF triggers on a view.

Syntax


Element	Description	Restrictions	Syntax
`owner`	The owner of `table` or `view`	Must own the table or view	Owner name
`table`	Table whose triggers are all to be enabled or disabled	Must exist	Identifier
`trigger`	Trigger to be enabled or disabled	Must exist	Identifier
`view`	View whose INSTEAD OF triggers are all to be enabled or disabled	Must exist	Identifier

Usage

The SET TRIGGERS statement is a special case of the SET Database Object Mode statement. The SET Database Object Mode statement can also enable or disable an index or a constraint, or change the filtering mode of a unique index or of a constraint.

For the complete syntax and semantics of the SET TRIGGERS statement, see SET Database Object Mode statement.

Restrictions on secondary servers

In cluster environments, the SET TRIGGERS statement is not supported on updatable secondary servers. (More generally, session-level index, trigger, and constraint modes that the SET Database Object Mode statement specifies are not redirected for UPDATE operations on table objects in databases of secondary servers.)