Neoview SQL Reference Manual (R2.5)

ALTER TRIGGER Statement
• “Syntax Description of ALTER TRIGGER”
• “Considerations for ALTER TRIGGER”
• “Examples of ALTER TRIGGER”
The ALTER TRIGGER statement is used to enable or disable triggers, individually or by SQL
tables.
ALTER TRIGGER { ENABLE trigger-name
| ENABLE ALL OF table-name
| DISABLE trigger-name
| DISABLE ALL OF table-name}
Syntax Description of ALTER TRIGGER
trigger-name
specifies the name of the trigger to alter. See “Database Object Names” (page 242).
table-name
specifies the name of the table that this trigger is defined on. See “Database Object Names”
(page 242).
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 the table, be the schema owner, or be granted the ALTER
privilege. Only the table owner or schema owner can specify ALTER TRIGGER DISABLE ALL
or ALTER TRIGGER ENABLE ALL
Examples of ALTER TRIGGER
Enable all triggers defined on table prescription:
alter trigger enable all of prescription;
Disable trigger alternate_drug:
alter trigger disable alternate_drug;
ALTER TRIGGER Statement 53