/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

4 votes245 views4 answers
Rollback in sql
SQL
10 votes252 views2 answers
Mysql alter add foreign key
SQL
0 vote232 views1 answer
Mysql add comment to column
SQL
0 vote207 views1 answer
Mariadb list tables
SQL
-3 votes226 views1 answer
Remove spaces sql 2008
SQL
1 vote248 views1 answer
Cross schema query oracle 2 users
SQL
3 votes246 views2 answers
How to open postgresql in windows
SQL
25 votes251 views3 answers
How to use a database to see tables mysql
SQL
5 votes274 views1 answer
Add column table sql default value
SQL
2 votes233 views1 answer
Set boolean flasksql
SQL

Share