Member Avatar for Stju

Let's use the basic example..
I have a table for tree representation with just 3 columns: ID, PARENT_ID,NAME. If I delete a record X, how can I delete all recursive records that refer as PARENT_ID of deleted record?

  • 2 Contributors
  • 1 Reply
  • 125 Views
  • 3 Years Discussion Span
  • Latest Post Latest Post by Rahul47
Member Avatar for Rahul47

You need to set ON DELETE CASCADE while defining foreign key in Child table.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.