DROP TRIGGER v17

Name

DROP TRIGGER  Remove a trigger.

Synopsis

DROP TRIGGER <name>

Description

DROP TRIGGER removes a trigger from its associated table. A superuser or the owner of the associated table can run the command.

Parameters

name

The name of a trigger to remove.

Examples

Remove a trigger named emp_salary_trig:

DROP TRIGGER emp_salary_trig;

See also

CREATE TRIGGER, ALTER TRIGGER