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 ?