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;
See also
solidDB® SQL statements