You can drop a trigger by using the DROP TRIGGER statement.
DROP TRIGGER trigger_name [ ; ]
- trigger_name : Specifies the name of the trigger to be dropped.
The following example shows how to drop the medal_trig trigger.
DROP TRIGGER medal_trig;
- 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.