DROP TRIGGER — Remove a trigger.
DROP TRIGGER
DROP TRIGGER <name>
DROP TRIGGER removes a trigger from its associated table. A superuser or the owner of the associated table can run the command.
name
The name of a trigger to remove.
Remove a trigger named emp_salary_trig:
emp_salary_trig
DROP TRIGGER emp_salary_trig;
CREATE TRIGGER, ALTER TRIGGER
DROP TABLESPACE
Database Compatibility for Oracle Developers: SQL
DROP TYPE