Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 17 » SQL Anywhere Server - SQL Reference » SQL statements » Alphabetical list of SQL statements

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
  • Change the definition of a trigger
    ALTER TRIGGER trigger-name trigger-definition
    trigger-definition : CREATE TRIGGER syntax
  • Obfuscate a trigger definition
    ALTER TRIGGER trigger-name ON [owner.] table-name SET HIDDEN
Remarks
  • Change the definition of a trigger

    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.

  • Obfuscate a trigger definition

    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 available through procedure profiling.

    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
  • ANSI/ISO SQL Standard

    Not in the standard.