/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 vote331 views1 answer
Soql last week
SQL
0 vote334 views1 answer
Syntax for changing column size in mysql
SQL
0 vote336 views1 answer
Mssql check if date is greater than today
SQL
0 vote317 views1 answer
Mysql events not work
SQL
0 vote342 views1 answer
Simple plsql program run in oracle sql developer but got the error
SQL
5 votes315 views1 answer
Oracle list packages
SQL
5 votes391 views1 answer
Oracle get ddl
SQL
2 votes335 views2 answers
How to DROP a table in mysql
SQL
6 votes377 views2 answers
Subtr Oracle ?
SQL
0 vote380 views1 answer
Sql set data from a select query to a temp table and insert
SQL

Share