DROP TRIGGER

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.

Which of the following issues have you encountered?

Content is inconsistent with the product UI

Unclear descriptions

Lack of examples or code

Incorrect steps

Can't find what I need

Lack of best practices

Feedback (optional)

0/500

Select at least one type of issue, and enter your comments or suggestions.

Enter a maximum of 500 characters.

Submit Cancel