ALTER TRIGGER statement

Replaces a trigger definition with a modified version. You must include the entire new trigger definition in the ALTER TRIGGER statement. This statement applies to SAP Sybase IQ catalog store tables only.

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

Privileges

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

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