¶
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.