Which command is used to delete a trigger?

by

DROP TRIGGER command.

In PL/SQL, there is no specific command exclusively designed to delete a trigger. Instead, you use the DROP TRIGGER statement to remove a trigger from the database.

Here’s the basic syntax:

DROP TRIGGER [schema.]trigger_name;

Replace [schema.]trigger_name with the appropriate schema and trigger name you want to delete.

For example:

DROP TRIGGER my_schema.my_trigger;

This statement removes the specified trigger from the database. Make sure you have the necessary privileges to drop the trigger, and be cautious, as dropping a trigger is a permanent action.