Existing name for the trigger.
- database_name
- user_name
- Optional name of the containing database or user for the trigger to be renamed if other than the current database or user.
Example: Rename a Trigger
This statement renames the parent_tab trigger to parent_table.
RENAME TRIGGER parent_tab TO parent_table;