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 expenses
;
DROP TRIGGER sendmail ON expenses;
The 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