title: How to delete record in Parent table without affecting the Child table?
body: <p>I have 2 tables in my database, Table A and Table B.</p>
  
  <p>Table A is a Master table and table B is a Transaction table. Table B have Foreign Key (IdTableA)</p>
  
  <p>Example : </p>
  
  <p>I already have a record in table B with IdTableA in it.</p>
  
  <p>INSERT INTO Table_B VALUES (IdTableB, IdTableA, 500000);</p>
  
  <p>and when I tried to delete record in Table A which is IdTableA there is an error.</p>
  
  <p>I want to delete a record in Table A without affecting record in Table B</p>
  
  <p>what should i do ? is it possible ?</p>