/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

1 vote145 views1 answer
File /etc/init.d/mysql not exists
SQL
2 votes208 views1 answer
Copy all values of a column to another column in sql in same table
SQL
0 vote209 views1 answer
ACCEPT nome PROMPT on oracle
SQL
4 votes151 views1 answer
And or sql order of operations
SQL
1 vote200 views7 answers
Filter
SQL
0 vote188 views1 answer
Do postgresql
SQL
2 votes240 views1 answer
Datetrunc
SQL
4 votes192 views4 answers
Date less than in sql
SQL
2 votes207 views1 answer
Docker run postgres locally
SQL
0 vote197 views1 answer
Convert uniqueidentifier to varchar in sql
SQL

Share