Use this statement to drop an event from the database.
DROP EVENT [ IF EXISTS ] [ owner.]event-name
Use the IF EXISTS clause if you do not want an error returned when the DROP EVENT statement attempts to remove an event that does not exist.
Any user who owns the object, or has DBA authority, can execute the DROP EVENT statement.
Automatic commit. Clears the Results tab in the Results pane in Interactive SQL.
SQL/2003 Core feature.
Drop MyEvent from the database. If the event does not exist, an error is returned.
DROP EVENT MyEvent;
|Discuss this page in DocCommentXchange.
Send feedback about this page using email.
|Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1|