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



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


Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file