Skip to main content

Foreign key : Delete child rows when deleting the parent PK ?

  • June 20, 2016
  • 0 replies
  • 1 view

Isabelle_Vela
Forum|alt.badge.img+1

Hello

 

If a "child" table is linked to a "father" via foreign key , are the "children" rows deleted when the "father" key they reference is deleted ?

Is there a CASCADE option either in the FK creation or delete statement ? I cannot find it in the documentation.

 

If this option exsits, does it work with TRUNCATE PARTITION also ?

 

 

Thank you

Isabelle