drop_event_trigger(7)

NAME#

DROP_EVENT_TRIGGER - remove an event trigger

SYNOPSIS#

DROP EVENT TRIGGER [ IF EXISTS ] \nname\n [ CASCADE | RESTRICT ]

DESCRIPTION#

DROP EVENT TRIGGER removes an existing event trigger. To execute this command, the current user must be the owner of the event trigger.

PARAMETERS#

IF EXISTS

name

CASCADE

RESTRICT

EXAMPLES#

Destroy the trigger snitch:

DROP EVENT TRIGGER snitch;

COMPATIBILITY#

There is no DROP EVENT TRIGGER statement in the SQL standard.

SEE ALSO#

CREATE EVENT TRIGGER (CREATE_EVENT_TRIGGER(7)), ALTER EVENT TRIGGER (ALTER_EVENT_TRIGGER(7))