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

SQL/MX Statements
HP NonStop SQL/MX Reference Manual—540440-003
2-23
Examples of ALTER TABLE
CITY CHAR(15),
MGR CHAR(3),
UNIQUE (PNUM),
FOREIGN KEY (MGR)
REFERENCES STAFF_M(EMPNUM));
ALTER TABLE STAFF_M ADD FOREIGN KEY (PRI_WK)
REFERENCES PROJ_M (PNUM);
Suppose further that you now need to drop the foreign key. Use SHOWDDL to
obtain the key’s system identification:
>>showddl staff_m;
CREATE TABLE NIST_EMB_CAT.SUN.STAFF_M
(
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
;