Sybase Adaptive Server Anywhere - ALTER TRIGGER Statement

ALTER TRIGGER statement
398
ALTER TRIGGER statement
Use this statement to replace 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 following the trigger name
Must be the owner of the table on which the trigger is defined, or be DBA, or
have ALTER permissions on the table and have RESOURCE authority.
Automatic commit.
"CREATE TRIGGER statement" on page 477
"CREATE TRIGGER statement" on page 480
"DROP statement" on page 505
The ALTER TRIGGER statement is identical in syntax to the CREATE
TRIGGER statement except for the first word. For information on trigger-
definition, see "CREATE TRIGGER statement" on page 477 and "CREATE
TRIGGER statement" on page 480.
Either the Transact-SQL or Watcom-SQL form of the CREATE TRIGGER
syntax can be used.
♦
SQL/92 Vendor extension
♦
Sybase Not supported by Adaptive Server Enterprise.
Function
Syntax
Permissions
Side effects
See also
Description
Standards and
compatibility