ALTER TRIGGER SQL - Language Statements ALTER TRIGGER change the definition of a trigger 2002-04-19 ALTER TRIGGER trigger ON table RENAME TO newname 2002-04-19 trigger The name of an existing trigger to alter. table The name of the table on which this trigger acts. newname New name for the existing trigger. 2002-04-19 ALTER TRIGGER Message returned from trigger renaming. ERROR Message returned if trigger is not available, or new name is a duplicate of another existing trigger on the table. 2002-04-19 ALTER TRIGGER changes the definition of an existing trigger. The RENAME clause causes the name of a trigger on the given table to change without otherwise changing the trigger definition. You must own the table on which the trigger acts in order to change its properties. 2002-04-19 Refer to CREATE TRIGGER for a further description of valid arguments. To rename an existing trigger: ALTER TRIGGER emp_stamp ON emp RENAME TO emp_track_chgs; 2002-04-19 The clause to rename triggers is a PostgreSQL extension from SQL92.