ALTER TRIGGER statement

Replaces a trigger definition with a modified version. You must include the entire new trigger definition in the ALTER TRIGGER statement.

Syntax 1 - Change the definition of a trigger

ALTER TRIGGER trigger-name trigger-definition

trigger-definition : CREATE TRIGGER syntax

Syntax 2 - Obfuscate a trigger definition

ALTER TRIGGER trigger-name ON [owner.] table-name SET HIDDEN

Remarks

Syntax 1 – The ALTER TRIGGER statement is identical in syntax to the CREATE TRIGGER statement except for the first word.
Either the Transact-SQL or Watcom SQL form of the CREATE TRIGGER syntax can be used.
Syntax 2 – You can use SET HIDDEN to obfuscate the definition of the associated trigger and cause it to become unreadable. The trigger can be unloaded and reloaded into other databases.
Note: The SET HIDDEN operation is irreversible.

Privileges

You must be the owner of the underlying table, or have the one of the following privileges:

ALTER privilege on the underlying table with the CREATE ANY OBJECT system privilege
ALTER ANY TRIGGER system privilege
ALTER ANY OBJECT system privilege

To alter a trigger on a view owned by someone else, you must have either the ALTER ANY TRIGGER and ALTER ANY VIEW system privileges, or you must have the ALTER ANY OBJECT system privilege.

Side effects

Automatic commit.

Standards and compatibility

SQL/2008 – Vendor extension.