DROP TRIGGER

Description

You can drop a trigger by using the DROP TRIGGER statement.

Syntax

DROP TRIGGER trigger_name [ ; ] 

• trigger_name : Specifies the name of the trigger to be dropped.

Example

The following is an example of dropping the medal_trig trigger.

DROP TRIGGER medal_trig;

Caution

• A user trigger (i.e. the trigger event is COMMIT or ROLLBACK) can be seen and dropped only by the owner.
• Only one trigger can be dropped by a single DROP TRIGGER statement. A table trigger can be dropped by a user who has an ALTER authorization on the table.