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

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

Leave a Comment

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

Can't find what you're looking for? Search the Vertica Documentation, Knowledge Base, or Blog for more information.