Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 17 » SQL Anywhere Server - SQL Reference » SQL statements » Alphabetical list of SQL statements

DROP EVENT statement

Drops an event from the database.

Syntax
DROP EVENT [ IF EXISTS ] event-name 
Remarks

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.

Events are not owned so do not specify an owner (an owner specification is ignored).

Privileges

You must have either the MANAGE ANY EVENT or DROP ANY OBJECT system privilege.

Side effects

Automatic commit.

Standards
  • ANSI/ISO SQL Standard

    Not in the standard.

Example

This example drops a fictitious example, MyEvent, from the database.

DROP EVENT MyEvent;