Deletes a trigger.

Syntax

DROP TRIGGER name

Description

You can use the DROP TRIGGER command to delete a trigger from its associated table. Only a superuser or the owner of the table on which the trigger is defined can run this command.

Parameters

ParameterDescription
Parameter Description
name The name of a trigger to be deleted.

Examples

Delete the emp_sal_trig trigger:

DROP TRIGGER emp_sal_trig;