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

ALTER TRIGGER

Function

ALTER TRIGGER renames a trigger.

Currently, only the name can be modified.

Precautions

Only the owner of a table where the trigger is created and a system administrator can run the ALTER TRIGGER statement.

Syntax

ALTER TRIGGER trigger_name ON table_name RENAME TO new_name;

Parameter Description

  • trigger_name

    Specifies the name of the trigger to be modified.

    Value range: an existing trigger

  • table_name

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

    Value range: an existing table having a trigger

  • new_name

    Specifies the new name after modification.

    Value range: a string, which complies with the identifier naming convention. A value contains a maximum of 63 characters and cannot be the same as other triggers on the same table.

Examples

See examples in CREATE TRIGGER.

Helpful Links

CREATE TRIGGER, DROP TRIGGER, and ALTER TABLE

Parent topic: SQL Syntax