Because of the different namespaces for triggers, specifying a trigger name in SAP MaxDB does not uniquely identify the trigger.
For this reason, SAP MaxDB only accepts the DROP TRIGGER (drop_trigger_statement) SQL statement with the following restriction: The table that the trigger refers to must be specified explicitly (see also DROP TRIGGER statement (drop_trigger_statement)).