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)


© Copyright SS64.com 1999-2014
Some rights reserved