Reference Manual
CHAPTER 9. SQL Statements
To replace a trigger definition with a modified version.
You must include the entire new trigger definition in the ALTER TRIGGER statement.
ALTER TRIGGER trigger-name trigger-time trigger-event [, trigger-event,..]
... [ ORDER integer ] ON table-name
... [ REFERENCING [ OLD AS old-name ]
[ NEW AS new-name ] ]
[ REMOTE AS remote-name ] ]
... [ FOR EACH { ROW | STATEMENT } ]
... [ WHEN ( search-condition ) ]
... [ IF UPDATE ( column-name ) THEN
... [ { AND | OR } UPDATE ( column-name ) ] ... ]
... compound-statement
... [ ELSEIF UPDATE ( column-name ) THEN
... [ { AND | OR } UPDATE ( column-name ) ] ...
... compound-statement
... END IF ] ]
trigger-time:
BEFORE | AFTER | RESOLVE
trigger-event:
DELETE | INSERT | UPDATE | UPDATE OF column-list
Must be the owner of the table on which the trigger is defined, or be DBA, or have ALTER permissions on the table.
Automatic commit.
The ALTER TRIGGER statement is identical in syntax to the CREATE TRIGGER statement except for the first word. The ALTER TRIGGER statement replaces the entire contents of the CREATE TRIGGER statement with the contents of the ALTER TRIGGER statement.
SQL/92 Vendor extension
Sybase Not supported by Adaptive Server Enterprise.