FIT
100
Advanced Data Management Commands
v
Primary and Foreign Key Designation
o
Examples:
;
ALTER TABLE PRODUCT
ADD PRIMARY KEY (P_CODE);
;
;
ALTER TABLE PRODUCT
ADD FOREIGN KEY (V_CODE) REFERENCES VENDOR;