DROP TRIGGER

An SQL command for removing a trigger

DROP TRIGGER is a DDL command for removing a trigger.

DROP TRIGGER was added in PostgreSQL 6.2.

Change history

Examples

Basic usage example for DROP TRIGGER:

postgres=# DROP TRIGGER trg_foo_aud_01 ON foo;
DROP TRIGGER

Attempting to drop a non-existent trigger:

postgres=# DROP TRIGGER trg_foo_aud_02 ON foo;
ERROR:  trigger "trg_foo_aud_02" for table "foo" does not exist

Categories

DDL, SQL command, Trigger

See also

CREATE TRIGGER, ALTER TRIGGER