title: Sql server - recursive delete
body: <p>I'm trying to delete user's data and all it's related data that is located in different tables.
  All the tables have Foreign Keys but without cascade delete. </p>
  
  <p>I investigated some options:   </p>
  
  <ol>
  <li>Enable cascade delete on all FK, delete and remove the cascade delete.   </li>
  <li>Delete from bottom UP, loop up for all the leaves delete and repeat this operation till Root.</li>
  </ol>
  
  <p>Are there any more smart option or other Techniques?</p>
  
  <p>I'm using Microsoft SQL Server 2012 (SP1)</p>