Help Center> Data Warehouse Service> SQL Syntax Reference> DDL Syntax> DROP TRIGGER
View PDF

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

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.

Helpful Links

CREATE TRIGGER, ALTER TRIGGER, ALTER TABLE

Parent topic: DDL Syntax