11.16.3. The DROP TRIGGER statement

DROP TRIGGER qualified_name

This drops a trigger of the given name. The name may optionally have a qualifier and owner, in which case these should be the qualifier and owner of the subject table of the trigger. Identical trigger names may exist for identically named tables in different namespaces.