SQL/MX 3.2 Reference Manual (H06.25+, J06.14+)

SQL/MX Statements
HP NonStop SQL/MX Release 3.2 Reference Manual—691117-001
2-41
Syntax Description of 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 more information, see Identifiers on page 6-56.
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 or object owner. 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};