Recursive Function to remove rows from Parent and Child Tables

• ericwenger1

  Hall of Fame

  Points: 3436

  More actions

  September 26, 2017 at 3:49 pm

  #340403

  I have a database that needs to have inactive companies removed along with all of the related child records that relate.
  I have identified all of the Parent/Child relationships that are involved, but was wondering if anyone had a function/script
  that  would  use recursive SQL to do this.

  Thanks in advance.

• tim.ffitch

  SSC Veteran

  Points: 292

  More actions

  September 27, 2017 at 4:12 am

  #1961114

  Find all of the relationships and turn on cascade delete, then all you need to is delete the company records.
  
  https://stackoverflow.com/questions/6260688/how-do-i-use-cascade-delete-with-sql-server