/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 vote144 views1 answer
Oracle synonym procedure dblink
SQL
0 vote132 views1 answer
Oracle locked objects
SQL
0 vote151 views1 answer
How to change mysql root password in windows 10
SQL
1 vote136 views1 answer
Mysql how to reset primary key
SQL
5 votes170 views2 answers
Mysql dump mysql db cli
SQL
0 vote145 views1 answer
Setval postgres example table id
SQL
0 vote142 views2 answers
Mysql get routine parameter list
SQL
17 votes158 views2 answers
Mysql date to string
SQL
10 votes215 views2 answers
Doublon sql
SQL
0 vote195 views1 answer
Restart serial number for postgres
SQL

Share