title: MySQL truncate error
body: <p>Trying remove all data and reset the AUTOMATIC_INCREMENT to the value of 0, so that I have a clean database to work with. Found a truncate function that should allow me to to do the above however it throws back this error.... <strong>Cannot truncate a table referenced in a foreign key constraint</strong> </p>
  
  <pre><code>(`film`.`reviewed`, CONSTRAINT `reviewed_ibfk_1` FOREIGN KEY (`movie_id`) REFERENCES `film`.`films` (`movie_id`))
  </code></pre>
  
  <p>Do this mean I have to remove the FOREIGN KEY ?</p>