SQL/MX 2.x Reference Manual (H06.10+, J06.03+)

SQL/MX Statements
HP NonStop SQL/MX Reference Manual—544517-008
2-24
Examples of ALTER TABLE
EMPNUM CHAR(3) CHARACTER SET
ISO88591 COLLATE
DEFAULT NO DEFAULT -- NOT NULL NOT DROPPABLE
, EMPNAME CHAR(20) CHARACTER SET
ISO88591 COLLATE
DEFAULT DEFAULT NULL
, GRADE DECIMAL(4, 0) DEFAULT
NULL
, CITY CHAR(15) CHARACTER SET
ISO88591 COLLATE
DEFAULT DEFAULT NULL
, PRI_WK CHAR(3) CHARACTER SET
ISO88591 COLLATE
DEFAULT DEFAULT NULL
, CONSTRAINT NIST_EMB_CAT.SUN.STAFF_M_452683997_9541 CHECK
(NIST_EMB_CAT.SUN.STAFF_M.EMPNUM IS NOT NULL) NOT
DROPPABLE
)
LOCATION \DRP45.$D45101.ZSDBV6VZ.D873HP00
NAME DRP45_D45101_ZSDBV6VZ_D873HP00
;
-- The following index is a system created index --
CREATE UNIQUE INDEX STAFF_M_187893997_9541 ON
NIST_EMB_CAT.SUN.STAFF_M
(
EMPNUM ASC
)
LOCATION \DRP45.$D45101.ZSDBV6VZ.VTW5HP00
NAME DRP45_D45101_ZSDBV6VZ_VTW5HP00
;
-- The following index is a system created index --
CREATE INDEX STAFF_M_859182618_9541 ON
NIST_EMB_CAT.SUN.STAFF_M
(
PRI_WK ASC
)
LOCATION \DRP45.$D45101.ZSDBV6VZ.SWBSQP00
NAME DRP45_D45101_ZSDBV6VZ_SWBSQP00
;
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.