MySQL Tutorial/Trigger/Drop Trigger

Looking at the CREATE statement in the data directory:

<data directory>/<database name>/<table name>.TRG

The DROP TRIGGER statement

In a DROP TRIGGER statement, the table name must be prepended to the name of the trigger:

DROP TRIGGER <table name>.<trigger name>