- Documentation Library
- Table of Contents
- MySQL 6.0 Reference Manual
- MySQL 5.1 Reference Manual
- MySQL 5.0 Reference Manual
- MySQL 3.23/4.0/4.1 Manual
- Table of Contents
Additional languages
MySQL 6.0 Reference Manual :: 12 SQL Statement Syntax :: 12.1 Data Definition Statements :: 12.1.17 DROP EVENT Syntax
Section Navigation [Toggle]
- 12.1 Data Definition Statements
- 12.1.1 ALTER DATABASE Syntax
- 12.1.2 ALTER EVENT Syntax
- 12.1.3 ALTER PROCEDURE and ALTER FUNCTION Syntax
- 12.1.4 ALTER SERVER Syntax
- 12.1.5 ALTER TABLE Syntax
- 12.1.6 ALTER VIEW Syntax
- 12.1.7 CREATE DATABASE Syntax
- 12.1.8 CREATE EVENT Syntax
- 12.1.9 CREATE FUNCTION Syntax
- 12.1.10 CREATE INDEX Syntax
- 12.1.11 CREATE PROCEDURE and CREATE FUNCTION Syntax
- 12.1.12 CREATE SERVER Syntax
- 12.1.13 CREATE TABLE Syntax
- 12.1.14 CREATE TRIGGER Syntax
- 12.1.15 CREATE VIEW Syntax
- 12.1.16 DROP DATABASE Syntax
- 12.1.17 DROP EVENT Syntax
- 12.1.18 DROP FUNCTION Syntax
- 12.1.19 DROP INDEX Syntax
- 12.1.20 DROP PROCEDURE and DROP FUNCTION Syntax
- 12.1.21 DROP SERVER Syntax
- 12.1.22 DROP TABLE Syntax
- 12.1.23 DROP TRIGGER Syntax
- 12.1.24 DROP VIEW Syntax
- 12.1.25 RENAME TABLE Syntax
DROP EVENT [IF EXISTS] event_name
This statement drops the event named
event_name. The event immediately
ceases being active, and is deleted completely from the server.
If the event does not exist, the error ERROR 1517
(HY000): Unknown event
'event_name' results. You
can override this and cause the statement to generate a warning
for non-existent events instead using IF
EXISTS.
An event can be dropped by any user having the
EVENT privilege on the database schema to which
the event to be dropped belongs.
© 1995-2008 MySQL AB, 2008 Sun Microsystems, Inc.
User Comments
Add your own comment.