0
How can i add foriegn key in nested table ?
this is my code ALTER TABLE vac_nt ADD CONSTRAINT VAC FOREIGN KEY (ID_VaccinationCenter) REFERENCES vac_nt(ID_VaccinationCenter); this is Error report - ORA-30730: referential constraint not allowed on nested table column 30730. 00000 - "referential constraint not allowed on nested table column" *Cause: An attempt was made to define a referential constraint on a nested table column. *Action: Do not specify referential constraints on nested table columns.
1 ответ
+ 1
The error message indicated you were using Oracle, so for the sake of context clarity, please tag Oracle or PLSQL rather than MySQL ☝