Modify and drop a trigger

You can modify and drop a trigger in PL.

Modify a trigger

To modify a trigger, you can use only the REPLACE TRIGGER statement. This statement is a data definition language (DDL) statement.

Generally, you can use the following statement to create or modify a trigger:

CREATE OR REPLACE TRIGGER trigger_name ...

If the value of trigger_name does not exist, the trigger is created. If the value of trigger_name exists, it is modified.

Drop a trigger

You can use the DROP TRIGGER statement to drop a trigger by using the following syntax:

DROP TRIGGER trigger_name;

When you drop a table, the triggers created on the table are also dropped.