Show TOC

ALTER TRIGGER statementLocate this document in the navigation structure

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 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
  • 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
    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
  • SQL/2008

    Vendor extension.