/SQL/Cannot truncate a table referenced in a foreign key constraint

Cannot truncate a table referenced in a foreign key constraint

Cannot truncate a table referenced in a foreign key constraint

SET FOREIGN_KEY_CHECKS = 0; 
TRUNCATE table $table_name; 
SET FOREIGN_KEY_CHECKS = 1;

3

Source: stackoverflow.com

Syntax error or access violation: 1701 Cannot truncate a table referenced in a foreign key constraint

As the error says, you can not truncate tables referenced by foreign keys. 
Delete should work though...

DB::table('some_table')->delete();

0

How to force truncate a table in mysql

DELETE FROM mytest.instance;
ALTER TABLE mytest.instance AUTO_INCREMENT = 1;

0

Similar codes

0 vote239 views1 answer
Postgresql alter column nullable
SQL
0 vote229 views1 answer
Soql last week
SQL
12 votes261 views4 answers
How to check mysql version ubuntu
SQL
0 vote256 views1 answer
Create table split string function in sql server
SQL
0 vote240 views1 answer
How to reset the database value in SQL server
SQL
0 vote228 views1 answer
Call function in query sql server
SQL
-1 vote261 views1 answer
Mysql faster insert
SQL
0 vote232 views1 answer
Adding conditions in MERGE statement in Oracle SQL for INSERT/UPDATE
SQL
0 vote229 views1 answer
Get cpu details sql
SQL
0 vote233 views1 answer
How to output a different column name in mysql
SQL

Share