DROP EVENT TRIGGER

Function

DROP EVENT TRIGGER deletes an event trigger.

Precautions

Only the super user or system administrator has the permission to delete an event trigger.

Syntax

DropEventTrigger ::= DROP EVENT TRIGGER [ IF EXISTS ] name [ CASCADE | RESTRICT ]

Parameter Description

• IF EXISTS

  Reports a notice instead of an error if the specified event trigger does not exist.

• name

  Specifies the name of the event trigger to be deleted.

  Value range: all existing event triggers.

• CASCADE | RESTRICT

  • CASCADE: automatically deletes the objects that depend on the trigger.
  • RESTRICT: refuses to delete the trigger if any objects depend on it. This is the default action.

Examples

For details, see examples in CREATE EVENT TRIGGER.

Helpful Links

ALTER EVENT TRIGGER, CREATE EVENT TRIGGER