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

Syntax error or access violation: 1701 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

Similar codes

0 vote287 views1 answer
Wincc 7.4 to sql stackoverflow
SQL
0 vote257 views1 answer
Html css mobile menu arrow dropdown
SQL
0 vote291 views1 answer
ValueError: A string literal cannot contain NUL (0x00) characters.
SQL
0 vote328 views1 answer
Mysql get nth highest
SQL
2 votes299 views2 answers
Spring import sql
SQL
26 votes269 views2 answers
What is the sql statement that finds duplicate usernames
SQL
1 vote278 views1 answer
DATE_SUB postgres
SQL
53 votes547 views6 answers
How to install mysql ubuntu
SQL
1 vote279 views1 answer
Mysql illegal mix of collations for operation 'join'
SQL
0 vote268 views1 answer
Rabbitmq service not starting
SQL

Share