Help Center/ GaussDB/ Developer Guide(Distributed_2.x)/ SQL Reference/ SQL Syntax/ DROP TRIGGER
Updated on 2023-10-23 GMT+08:00
View PDF
Share

DROP TRIGGER

Function

DROP TRIGGER deletes a trigger.

Precautions

Only the owner of a trigger or a system administrator has the DROP TRIGGER permission.

Syntax

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

Parameter Description

  • IF EXISTS

    Reports 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 name

  • table_name

    Specifies the name of the table containing the trigger.

    Value range: name of the table containing the trigger

  • CASCADE | RESTRICT
    • CASCADE: automatically deletes the objects that depend on the trigger.
    • RESTRICT: refuses to delete the trigger if any objects depend on it. This is the default action.

Examples

For details, see Examples in CREATE TRIGGER.

Helpful Links

CREATE TRIGGER, ALTER TRIGGER, and ALTER TABLE

Parent topic: SQL Syntax