ALTER EVENT TRIGGER ​

Function ​

ALTER EVENT TRIGGER modifies an event trigger.

Precautions ​

Only the system administrator or super user has the permission to modify event triggers.

Syntax ​

ALTER EVENT TRIGGER name DISABLE
ALTER EVENT TRIGGER name ENABLE [ REPLICA | ALWAYS ]
ALTER EVENT TRIGGER name OWNER TO { new_owner | CURRENT_USER | SESSION_USER }
ALTER EVENT TRIGGER name RENAME TO new_name

Parameter Description ​

• name

  Specifies the name of the event trigger to be modified.

  Value range: all existing event triggers.

• new_name

  Specifies the new name after modification.

  Value range: strings that comply with the identifier naming convention. A value contains a maximum of 63 characters and cannot be the same as other event triggers on the same table.

Examples ​

For details, see Examples in CREATE EVENT TRIGGER.

Helpful Links ​

CREATE EVENT TRIGGER and DROP EVENT TRIGGER