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
Parameter | Description |
---|
Parameter | Description |
---|---|
name | The name of a trigger to be deleted. |
Examples
Delete the emp_sal_trig
trigger:
DROP TRIGGER emp_sal_trig;