/SQL/Error 1451 (23000): cannot delete or update a parent row: a foreign key constraint fails

Error 1451 (23000): cannot delete or update a parent row: a foreign key constraint fails

Error 1451 (23000): cannot delete or update a parent row: a foreign key constraint fails

SET FOREIGN_KEY_CHECKS = 0; -- to disable FK checks (ex: for delete purpose)
SET FOREIGN_KEY_CHECKS = 1; -- to re-enable FK checks

1

Sqlstate[23000]: integrity constraint violation: 1451 cannot delete or update a parent row:

Schema::disableForeignKeyConstraints();
Schema::dropIfExists('tablename');
Schema::enableForeignKeyConstraints();

0

ERROR 1451: 1451: Cannot delete or update a parent row: a foreign key constraint fails

SET FOREIGN_KEY_CHECKS=0; -- to disable them
SET FOREIGN_KEY_CHECKS=1; -- to re-enable them

0

Source: stackoverflow.com

Similar codes

0 vote113 views1 answer
Ms sql filter all sympbol
SQL
4 votes109 views1 answer
Mysql biginteger size
SQL
24 votes104 views5 answers
Sql server insert into select
SQL
3 votes147 views1 answer
Apex call duration
SQL
0 vote163 views1 answer
How to find the most occuring in SQL
SQL
6 votes104 views2 answers
Postgresql restore from dump
SQL
2 votes117 views1 answer
Mysql shell insert into
SQL
0 vote104 views1 answer
How to convert DateTime to VarChar SQL
SQL
0 vote105 views2 answers
How to combine diff colmun value using group by postgres
SQL
1 vote108 views1 answer
What is a Database?
SQL

Share