Name
DROP TRIGGER
Synopsis
DROP TRIGGER [IF EXISTS] [database.
]trigger
This statement deletes a trigger. The IF
EXISTS
keyword prevents error messages when the trigger
doesn’t exist. Instead, a note will be generated, which can be
displayed afterward by executing the SHOW WARNINGS
statement. You may specify the database or schema with which the
trigger is associated. If not given, the current default database is
assumed. As of version 5.1.6 of MySQL, this statement requires the
TRIGGER
privilege for the table related to the
trigger given. Previously, it required SUPER
privilege. When upgrading from version 5.0.10 or earlier of MySQL, be
sure to drop all triggers because there’s a problem with using or
dropping triggers from earlier versions.
Get MySQL in a Nutshell, 2nd Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.