DROP TRIGGER
Function
DROP TRIGGER deletes a trigger.
Precautions
Only the owner of a trigger and system administrators can run the DROP TRIGGER statement.
Syntax
1
|
DROP TRIGGER [ IF EXISTS ] trigger_name ON table_name [ CASCADE | RESTRICT ]; |
Parameter Description
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. |
|
Examples
Delete trigger insert_trigger.
1
|
DROP TRIGGER insert_trigger ON test_trigger_src_tbl; |
Helpful Links
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.