Renaming a Trigger

See Also

When you change the name of a trigger, the trigger name is updated in your database and in the Tables folder of Data View as soon as you save the trigger.

To rename a trigger

1. Open the trigger. For details, see Opening a Trigger.
   
   
2. In the source code editor, replace the existing trigger name with the new name. (The trigger name appears after the Create Trigger statement.)
   
   
3. Save the trigger. For details, see Saving a Trigger.
   
   
4. Delete the old trigger (unless you want two identical triggers with different names). For details, see Deleting a Trigger.

The new trigger name is in the database and is displayed in Data View.

For more information about editing the Create Trigger statement, see Creating a Trigger.