SQL/MX 2.x Reference Manual (H06.04+)

SQL/MX Statements
HP NonStop SQL/MX Reference Manual—540440-003
2-24
ALTER TRIGGER Statement
ALTER TABLE NIST_EMB_CAT.SUN.STAFF_M
ADD CONSTRAINT NIST_EMB_CAT.SUN.STAFF_M_187893997_9541
UNIQUE (EMPNUM)
DROPPABLE ;
ALTER TABLE NIST_EMB_CAT.SUN.STAFF_M
ADD CONSTRAINT NIST_EMB_CAT.SUN.STAFF_M_859182618_9541
FOREIGN KEY (PRI_WK)
REFERENCES NIST_EMB_CAT.SUN.PROJ_M(PNUM) DROPPABLE ;
--- SQL operation complete.
Now that you have the identification, you can drop the foreign key with ALTER
TABLE:
>>alter table staff_m drop constraint STAFF_M_859182618_9541;
--- SQL operation complete.
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 more information, see Identifiers on page 6-52.
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.
ALTER TRIGGER { ENABLE trigger-name |
ENABLE ALL OF table-name |
DISABLE trigger-name |
DISABLE ALL OF table-name};