lundi 29 juin 2015

What is Oracle's default FK behaviour ON DELETE?

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