/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

1 vote303 views1 answer
Homebrew install mysql
SQL
0 vote297 views2 answers
How to count codition
SQL
0 vote292 views1 answer
Selecting Multiple Columns in SQL
SQL
15 votes286 views5 answers
Show tables in oracle
SQL
0 vote319 views1 answer
How to use sqlcommand
SQL
10 votes332 views4 answers
Join multiple tables in sql
SQL
0 vote260 views1 answer
Postgres select except
SQL
-1 vote306 views2 answers
Sql search all tables for attributes
SQL
4 votes280 views2 answers
Show all database inside postgresql
SQL
1 vote273 views1 answer
Jooq convert using gbk
SQL

Share