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.

Examples

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 commands

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


 
Copyright © 1999-2024 SS64.com
Some rights reserved