You can change a trigger name by using the TRIGGER reserved word in the RENAME statement.
RENAME TRIGGER old_trigger_name AS new_trigger_name [ ; ]
- old_trigger_name: Specifies the current name of the trigger.
- new_trigger_name: Specifies the name of the trigger to be modified.
RENAME TRIGGER medal_trigger AS medal_trig;
- A trigger name must be unique among all trigger names. The name of a trigger can be the same as the table name in the database.
- To rename a table trigger, you must be the trigger owner or granted the ALTER authorization on the table where the trigger belongs. A user trigger can only be renamed by its user.