Home

Published

- 1 min read

Delete table ignore foreign key check - check foreign key 0

check-constraint ignore key sql truncate
img of Delete table ignore foreign key check - check foreign key 0

The solution for this is noted below

Delete table ignore foreign key check - check foreign key 0

Solution

   SET FOREIGN_KEY_CHECKS=0;
TRUNCATE TABLE `table_name`;
SET FOREIGN_KEY_CHECKS=1;

Try other methods by searching on the site. That is if this doesn’t work