title: How to delete a row ONLY in parent table, which is referenced by a Foregin Key from the child table
body: <p>I want to delete a row/tuple from a parent table, but it is throwing an error message because it has a FOREIGN KEY reference in its child table.</p>
  
  <p>However, in my case I want to <strong>delete the record only from the parent table and maintain the data in the child table</strong>.</p>
  
  <p>Is it possible to achieve this?</p>
  
  <p>I know the usage of <a href="https://stackoverflow.com/questions/3574290/how-we-delete-a-row-from-parent-table-when-child-table-connected-with-paren-tabl"><code>ON DELETE CASCADE</code></a>, but I want to know if there is a solution for the secenario I described?</p>