ALTER TRIGGER statement

Replaces 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-definition

trigger-definition : CREATE TRIGGER syntax

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

Syntax 1 The ALTER TRIGGER statement is identical in syntax to the CREATE TRIGGER statement except for the first word. For information about trigger-definition, see CREATE TRIGGER statement and CREATE TRIGGER statement [T-SQL].
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. If SET HIDDEN is used, debugging using the debugger does not show the trigger definition, nor is it be available through procedure profiling.

Note

The SET HIDDEN operation is irreversible.

Discuss this page in DocCommentXchange.