DOC HOME SITE MAP MAN PAGES GNU INFO SEARCH PRINT BOOK
 

(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