The DROP TRIGGER statement drops a trigger that is defined on a table.
For more information about triggers, see Triggers.
Examples
DROP TRIGGER update_acct_balance; -- Using schema and trigger name DROP TRIGGER savings_accounts.update_acct_balance; -- Using catalog, schema, and trigger name DROP TRIGGER accounts.savings_accounts.update_acct_balance;