Updated on 2024-05-07 GMT+08:00

ALTER TRIGGER

Description

Renames a trigger.

Currently, only the name can be modified.

Precautions

The owner of the table where a trigger resides or a user granted the ALTER ANY TRIGGER permission can perform the ALTER TRIGGER operation. A system administrator has this permission by default.

Syntax

1
ALTER TRIGGER trigger_name ON table_name RENAME TO new_name;

Parameters

  • 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 naming convention. A value contains a maximum of 63 characters and cannot be the same as other triggers on the same table.

Examples

For details, see CREATE TRIGGER.