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 example shows how to drop 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.