ALTER TRIGGER

SQL Guide : solidDB® SQL statements : ALTER TRIGGER

ALTER TRIGGER

ALTER TRIGGER trigger_name_attr SET {ENABLED | DISABLED}
trigger_name_attr ::= [ catalog_name.[ schema_name. ]]
trigger_name

Usage

The ALTER TRIGGER statement modifies trigger attributes. The valid attributes are ENABLED and DISABLED trigger.

The ALTER TRIGGER DISABLED statement causes solidDB^® to ignore the trigger when an activating DML statement is issued. With this command, you can also enable a trigger that is currently inactive or disable a trigger that is currently active.

To alter a trigger on a table, you must be the owner of the table, or a user with DBA authority.

Examples

ALTER TRIGGER trig_on_employee SET ENABLED;