DROP EVENT NOTIFICATION

Remove an event notification trigger from the current database.

Syntax
      DROP EVENT NOTIFICATION notification_name [,...n ]
        ON { SERVER | DATABASE | QUEUE queue_name }[;]

Key
   notification_name Name of the event notification to remove.

   SERVER            Indicates the scope of the event notification applies to the current server.

   DATABASE          Indicates the scope of the event notification applies to the current database.

   queue_name        Indicates the scope of the event notification applies to the queue specified by queue_name.

Options must must be specified as they originally were when the event notification was created.

If an event notification fires within a transaction and is dropped within the same transaction, the event notification instance is sent, and then the event notification is dropped.

Examples

DROP EVENT NOTIFICATION testnotify
ON DATABASE;

“Even a minor event in the life of a child is an event of that child's world and thus a world event” ~ Gaston Bachelard

Related commands

CREATE EVENT NOTIFICATION
ALTER ANY DATABASE EVENT NOTIFICATION (Database)
ALTER ANY EVENT NOTIFICATION (Server)