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.

Helpful Links

CREATE TRIGGER, DROP TRIGGER, and ALTER TABLE