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

SQL/MX Statements
HP NonStop SQL/MX Reference Manual—523725-004
2-25
Examples of ALTER TABLE
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.