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

ALTER TRIGGER

Updated at: Mar 13, 2020 GMT+08:00

Function

ALTER TRIGGER modifies the definition of a trigger.

Precautions

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

Syntax

1
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 that 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

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