Help Center > > Developer Guide> SQL Reference> SQL Syntax> DROP TRIGGER

DROP TRIGGER

Updated at: May 15, 2019 GMT+08:00

Function

DROP TRIGGER deletes a trigger.

Precautions

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

Syntax

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

Parameter Description

  • 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.

    Value range: an existing trigger

  • table_name

    Specifies the name of the table where the trigger to be deleted is located.

    Value range: an existing table having a trigger

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

Examples

For details, see CREATE TRIGGER.

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel