If I simply stipulate a constraint of the form:
ALTER TABLE childtbl
ADD (CONSTRAINT myfk
FOREIGN KEY(mycol)
REFERENCES parenttbl(mycol))
in an Oracle database, what is the default behaviour if I delete a row in parenttbl
?
CASCADE
?SET NULL
?RESTRICT
?NO ACTION
?
Aucun commentaire:
Enregistrer un commentaire