DROP TRIGGER

CASCADE: Deletes objects that depend on the trigger.
RESTRICT: Refuses to delete the trigger if any objects depend on it. This is the default.

DROP TRIGGER deletes a trigger.

Only the owner of a trigger and system administrators can run the DROP TRIGGER statement.

     DROP TRIGGER [ IF EXISTS ] trigger_name ON table_name [ CASCADE | RESTRICT ];

**Table 1** DROP TRIGGER parameters
Parameter	Description	Value Range
IF EXISTS	Sends a notice instead of an error if the specified trigger does not exist.	-
trigger_name	Specifies the name of the trigger to be deleted.	An existing trigger.
table_name	Specifies the name of the table where the trigger to be deleted is located.	An existing table having a trigger
CASCADE \| RESTRICT	Specifies how to process related data in the dependent object when a delete operation is performed.	CASCADE: Deletes objects that depend on the trigger. RESTRICT: Refuses to delete the trigger if any objects depend on it. This is the default.

Delete trigger insert_trigger.

     DROP TRIGGER insert_trigger ON test_trigger_src_tbl;

Parent Topic: DDL Syntax

Thank you very much for your feedback. We will continue working to improve the documentation.

The system is busy. Please try again later.