SET TRIGGERS

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

                   .-,-------.
                   V         |       .-ENABLED------.
>>-SET TRIGGERS--+---trigger-+----+--+-+----------+-+----------><
                 '-FOR--+-table-+-'    '-DISABLED-'
                        '-view--'

Element	Description	Restrictions	Syntax
table	Table whose triggers are all to be enabled or disabled	Must exist	Database Object Name, p. Database Object Name
trigger	Trigger to be enabled or disabled	Must exist	Database Object Name, p. Database Object Name
view	View whose INSTEAD OF triggers are all to be enabled or disabled	Must exist	Database Object Name, p. Database Object Name

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.