make MB_SERVER_PATH=~/dev/musicbrainz-server createdropsql 

creates DropTriggers.sql containing things like

 DROP TRIGGER search_annotation_insert ON musicbrainz;

Note that musicbrainz is used instead of the real table name.

I suspect this is since https://github.com/metabrainz/sir/commit/6d579d1ef4e1a44f2d57eea21922f71864b6453a.