Removes a trigger.
DROP TRIGGER [IF EXISTS] <name> ON <table> [CASCADE | RESTRICT]
DROP TRIGGER will remove an existing trigger definition. To run this command, the current user must be the owner of the table for which the trigger is defined.
Remove the trigger
sendmail on table
DROP TRIGGER sendmail ON expenses;
DROP TRIGGER statement in Greenplum Database is not compatible with the SQL standard. In the SQL standard, trigger names are not local to tables, so the command is simply
DROP TRIGGER name.
Parent topic: SQL Commands