DROP EVENT NOTIFICATION

Remove an event notification trigger from the current database.

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

Key:
    notification_name  Name of the event notification to remove.
    SERVER             Apply to the current server
    DATABASE           Apply to the current database
    queue              The name of the queue

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

Example

DROP EVENT NOTIFICATION testnotify

"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:

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