SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

SQL/MX Statements
HP NonStop SQL/MX Reference Manual—523725-004
2-26
ALTER TRIGGER Statement
ALTER TRIGGER Statement
Considerations for ALTER TRIGGER
The ALTER TRIGGER statement is used to enable or disable triggers, individually or
by SQL/MX table.
Syntax Description of ALTER TRIGGER
trigger-name
specifies the ANSI logical name of the trigger to be altered, of the form:
[[catalog-name.]schema-name.]trigger-name
where each part of the name is a valid SQL identifier with a maximum of 128
characters. For information, see Identifiers on page 6-54.
table-name
specifies the ANSI logical name of the table that this trigger is defined on, of the
form:
[[catalog-name.]schema-name.]table-name
where each part of the name is a valid SQL identifier with a maximum of 128
characters.
Considerations for ALTER TRIGGER
ENABLE ALL enables all triggers defined on table-name.
DISABLE ALL disables all triggers defined on table-name.
Authorization and Availability Requirements
To alter a trigger, you must own its schema or be the super ID. Only the super ID can
use ALTER TRIGGER DISABLE ALL or ALTER TRIGGER ENABLE ALL.
ALTER TRIGGER { ENABLE trigger-name |
ENABLE ALL OF table-name |
DISABLE trigger-name |
DISABLE ALL OF table-name};