(mysql.info) drop-trigger
Info Catalog
(mysql.info) create-trigger
(mysql.info) triggers
(mysql.info) using-triggers
18.2 `DROP TRIGGER' Syntax
==========================
DROP TRIGGER [SCHEMA_NAME.]TRIGGER_NAME
This statement drops a trigger. The schema (database) name is optional.
If the schema is omitted, the trigger is dropped from the default
schema. `DROP TRIGGER' was added in MySQL 5.0.2. Its use requires the
`SUPER' privilege.
* Prior to MySQL 5.0.10, the table name was required instead of
the schema name (`TABLE_NAME.TRIGGER_NAME'). When upgrading from a
previous version of MySQL 5 to MySQL 5.0.10 or newer, you must drop all
triggers _before upgrading_ and re-create them afterward, or else `DROP
TRIGGER' does not work after the upgrade. See
upgrading-from-4-1, for a suggested upgrade procedure.
Info Catalog
(mysql.info) create-trigger
(mysql.info) triggers
(mysql.info) using-triggers
automatically generated byinfo2html