Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Cascade Delete

forums › forums › SQLyog › Using SQLyog › Cascade Delete

  • This topic is empty.
Viewing 0 reply threads
  • Author
    Posts
    • November 8, 2012 at 1:20 pm #12842
      sanko
      Member

      I'm new to cascade delete.

      I have a parent table and 5 child tables . They are related through foreign keys.

      I want to delete child records if I remove parent record .

      I understand I need to enable delete cascade here in sqlyog.

      My query is where do I need to enable this ?

      I am confused which one of the below would be correct

      (A) right click on Parent table

      > Manage Relationship

      >Edit

      > enable radio Cascade Delete

      (B ) right click on all Child tables

      > Manage Relationship

      >Edit

      > enable radio Cascade Delete

      Can you please tell which one is correct ?

  • Author
    Posts
Viewing 0 reply threads
  • You must be logged in to reply to this topic.