Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

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

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