/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

1 vote192 views1 answer
Database Queries
SQL
0 vote183 views1 answer
Postpresql relation not found
SQL
2 votes184 views1 answer
How to make multiple keys as primary in bdms
SQL
1 vote176 views1 answer
Sql insert for each distinct value
SQL
0 vote168 views1 answer
What is the essence of SQL?
SQL
6 votes564 views3 answers
Sql select last id
SQL
0 vote183 views1 answer
Date 3 months from today sql
SQL
9 votes195 views3 answers
Where clause sql
SQL
2 votes181 views1 answer
Oracle trace session
SQL
0 vote189 views1 answer
Drop database using terminal postgres
SQL

Share