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;
|Envoyer votre avis sur cette page par email.||Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1|